OraFAQ Forum: Reports & Discoverer » can't use dynamic SQL in Reports?

Home » Developer & Programmer » Reports & Discoverer » can't use dynamic SQL in Reports?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can't use dynamic SQL in Reports? [message #87886]

Mon, 15 October 2001 16:03

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

----------------------------------------------------------------------

Report message to a moderator

Re: can't use dynamic SQL in Reports? [message #87901 is a reply to message #87886]

Mon, 22 October 2001 10:22

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

----------------------------------------------------------------------

Report message to a moderator

Re: can't use dynamic SQL in Reports? [message #88020 is a reply to message #87886]

Fri, 11 January 2002 04:05

Mik
Messages: 1
Registered: January 2002

Junior Member

Try using the SRW.DO_SQL procedure

Report message to a moderator

Previous Topic:	Re: Changing password in Discoverer
Next Topic:	report query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 04 20:14:08 CST 2025