Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#8 Execute fails with Table based variables

v1.0_(example)
closed-later
Steve Shaw
9
2013-12-06
2003-08-20
Steve Shaw
No

Execute fails when variable is a Table so following works:

set curn2 [oraopen $lda ]
set sql2 "BEGIN DBMS_OUTPUT.GET_LINE(:LINES,
:NUMLINES); END; "
oraparse $curn2 $sql2
oraplexec $curn2 $sql2 :NUMLINES {25} :LINES {NULL}
oraclose $curn1

But this doesn't:

set curn2 [oraopen $lda ]
set sql2 "BEGIN DBMS_OUTPUT.GET_LINES(:LINES,
:NUMLINES); END; "
oraparse $curn2 $sql2
oraplexec $curn2 $sql2 :NUMLINES {25} :LINES {NULL}
oraclose $curn1

PROCEDURE GET_LINE
Argument Name Type In/Out Default?
------------------------------ -----------------------
------ --------
LINE VARCHAR2 OUT
STATUS NUMBER(38) OUT
PROCEDURE GET_LINES
Argument Name Type In/Out Default?
------------------------------ -----------------------
------ --------
LINES TABLE OF VARCHAR2(255) OUT
NUMLINES NUMBER(38) IN/OUT

========================================================================

Discussion

  • Steve Shaw
    Steve Shaw
    2013-12-06

    • status: open --> closed-later
    • Group: --> v1.0_(example)
    • Priority: 5 --> 9