Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SWR.DO_SQL doesn't work with Report Builder 6.0.5.35.0 and Oracle 7.3.4.

57049Jan 10 2002
Hello, I'm trying to execute a report and here is my code for that:

function BeforePForm return boolean is
x Varchar2(100);
begin
x:= 'begin ssg$empresa.asigna_empresa(:p_empr); end;';
srw.do_sql(x);
return (TRUE);
EXCEPTION
when SRW.DO_SQL_FAILURE then
srw.message(100,'Error en activacisn de empresa: '||x);
return (FALSE);
end;

Can anyone help me out or can you tell me why my PC is hung when I want to
execute the report?
If my code doesn't take SRW.DO_SQL... then it works perfectly.
Sorry for my English and thanks a lot in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2002
Added on Jan 10 2002
0 comments
275 views