Home » RDBMS Server » Server Administration » Syntax question Dynamic SQL
Syntax question Dynamic SQL [message #370759] Tue, 01 February 2000 08:11
Messages: 20
Registered: January 2000
Junior Member

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);

cursor_id := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_id, cTrig, dbms_sql.v7);
nRows := DBMS_SQL.EXECUTE(cursor_id);

Procedure is compiling without errors, but on execution
I'm reciving following errors on second DBMS_SQL.PARSE command :

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 - Production
PL/SQL Release - 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