| Syntax question Dynamic SQL [message #370759] |
Tue, 01 February 2000 08:11 |
Laert
Messages: 20
Registered: January 2000
|
Junior Member |
|
|
Hi,
Can someone help me to fix following problem:
From stored procedure I'm doing follows
cursor_id := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_id, cTBCrtString || cIndex, dbms_sql.v7);
nRows := DBMS_SQL.EXECUTE(cursor_id);
DBMS_SQL.CLOSE_CURSOR(cursor_id);
cursor_id := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_id, cTrig, dbms_sql.v7);
nRows := DBMS_SQL.EXECUTE(cursor_id);
DBMS_SQL.CLOSE_CURSOR(cursor_id);
Procedure is compiling without errors, but on execution
I'm reciving following errors on second DBMS_SQL.PARSE command :
ERROR:
ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "My_proc", line 227
ORA-06512: at line 1
SQL*Plus internal error state 2087, context 47:0:0
Unsafe to proceed
I'm using
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
