| SRW.DO_SQL [message #89594] |
Mon, 31 May 2004 04:43  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
