Home » RDBMS Server » Server Administration » Syntax question Dynamic SQL
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
Previous Topic: selecting, updating user-defined data types
Next Topic: Impossible..................Possible............
Goto Forum:
  


Current Time: Thu Oct 22 03:27:34 CDT 2020