Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SQL.DEFINE_COLUMN error!
DBMS_SQL.DEFINE_COLUMN error! [message #36646] Sun, 09 December 2001 22:53 Go to next message
Gianni
Messages: 7
Registered: November 2001
Junior Member
Hi people,
I have some troubles about the DBMS_SQL procedure DEFINE_COLUMN. That is, I have this code:

val_cursor := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(val_cursor,str,DBMS_SQL.NATIVE);
DBMS_SQL.DEFINE_COLUMN(val_cursor,1,temp);
DBMS_SQL.DEFINE_COLUMN(val_cursor,2,temp2);
row_exec:= DBMS_SQL.EXECUTE(val_cursor);

But when I create the procedure I've this message:
TOO MANY DECLARATIONS OF DEFINE_COLUMN.
Can anybody helps me?
Regards Gianni

----------------------------------------------------------------------
Re: DBMS_SQL.DEFINE_COLUMN error! [message #36647 is a reply to message #36646] Sun, 09 December 2001 23:55 Go to previous message
Deepu
Messages: 3
Registered: December 2001
Junior Member
DBMS_SQL.DEFINE_COLUMN(val_cursor,1,temp,30);

when I gave the size of temp as 30 in the call to DBMS_SQL.DEFINE_COLUMN, the procedure got compiled properly.

----------------------------------------------------------------------
Previous Topic: Using UTL_FILE to read from a network drive
Next Topic: Trigger to display a message at Logon
Goto Forum:
  


Current Time: Thu Mar 28 07:41:28 CDT 2024