Home » Developer & Programmer » Reports & Discoverer » SRW.DO_SQL
SRW.DO_SQL [message #89594] Mon, 31 May 2004 04:43 Go to next message
surekha
Messages: 12
Registered: May 2001
Junior Member
PLZ tell me how to implement SRW.DO_SQL in reports 6i.i'm using it in the before report trigger but it is giving error like 'ora00984-column not allowed here'

plz let me know with one example

thanx in advance
Re: SRW.DO_SQL [message #89602 is a reply to message #89594] Wed, 02 June 2004 02:48 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Please provide the Sql statement which you have used as this is a Sysntax error problem.

A sample code is as follows:
function AfterReport return boolean is
begin
If :P_TEMP = 'X' Then
:P_QUERY := :P_QUERY||' AND NVL(OUTGOING_REQUEST_MASTER.AORM_FLAG,''X'') <>'||'''W''';
SRW.DO_SQL('Delete OUTGOING_REQUEST_MASTER '||:P_QUERY);
SRW.DO_SQL('Commit') ;
Else
SRW.DO_SQL('Delete OUTGOING_REQUEST_DETAILS '||:P_QUERY);
SRW.DO_SQL('Delete OUTGOING_REQUEST_MASTER '||:P_QUERY);
SRW.DO_SQL('Commit') ;
End If;
return (TRUE);
end;

Regards
Himanshu
Previous Topic: Can someone explain grouping please?
Next Topic: cancelling a report and running another.
Goto Forum:
  


Current Time: Wed Feb 28 15:55:29 CST 2024