Home » Developer & Programmer » Reports & Discoverer » can't use dynamic SQL in Reports?
can't use dynamic SQL in Reports? [message #87886] Mon, 15 October 2001 16:03 Go to next message
George
Messages: 68
Registered: April 2001
Member
Does report support dynamic SQL? I have a function like below but reports can't compile it:

create or replace FUNCTION emptest (dno NUMBER) RETURN NUMBER IS
query_str VARCHAR2(1000);
no_of_emp NUMBER;
BEGIN
query_str := ' SELECT count(*) from emp where deptno = :1 ';
execute immediate query_str into no_of_emp using dno;
return no_of_emp;
END;

Thanks

----------------------------------------------------------------------
Re: can't use dynamic SQL in Reports? [message #87901 is a reply to message #87886] Mon, 22 October 2001 10:22 Go to previous messageGo to next message
Venus Scott
Messages: 12
Registered: October 2001
Junior Member
Try the following site. On the right hand side is information about Dynamic SQL and reports.

http://www.phenoracle.co.uk/apps/jsp/menu.html

----------------------------------------------------------------------
Re: can't use dynamic SQL in Reports? [message #88020 is a reply to message #87886] Fri, 11 January 2002 04:05 Go to previous message
Mik
Messages: 1
Registered: January 2002
Junior Member
Try using the SRW.DO_SQL procedure
Previous Topic: Re: Changing password in Discoverer
Next Topic: report query
Goto Forum:
  


Current Time: Fri Mar 29 09:07:44 CDT 2024