Undefined select with DBMS_SQL [message #38913] |
Mon, 27 May 2002 05:36 |
JMP
Messages: 4 Registered: May 2002
|
Junior Member |
|
|
Hi !!
I try to use DBMS_SQL Package.
I need to use a dynamic SELECT, but I don't know the number and the type of column in the SELECT.
How to use DBMS_SQL package in this situation ?
Thank.
JMP
|
|
|
Re: Undefined select with DBMS_SQL [message #38914 is a reply to message #38913] |
Mon, 27 May 2002 06:44 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
/* use %type */
SQL> ed
Wrote file afiedt.buf
1 declare
2 a number;
3 retval emp.ename%type;
4 str varchar2(60);
5 begin
6 a:=&empno;
7 str:='select ename from emp where empno= (:b1) ';
8 execute immediate str into retval using a;
9 dbms_output.put_line(retval);
10* end;
SQL> /
Enter value for empno: 7788
old 6: a:=&empno;
new 6: a:=7788;
SCOTT
PL/SQL procedure successfully completed.
|
|
|