I meet a problem after I installed Event-Driven Publishing API (i.e. SRW).
package body "SRW" does not exist when I run my procedure.
I get the install script in direct <11ias_home>\reports\admin\sql\.
And I just run srwAPIins.sql to my database.
Did I miss some steps for installing?
The procedure as below:
CREATE OR REPLACE PROCEDURE PROCEDURE_TEST_REPORT
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
myIdent := srw.run_report(myPlist);
In which schema did you install the package? If it's not in the application schema, maybe you installed it in SYS, you need to grant execute to other users.
"srwAPIgrant.sql grants access privileges to the API. Run this script for each user to whom you will grant access to the API. If everyone may have access, you can run this once and grant access to PUBLIC."
Thanks a lot for your quick reply.
There is only one schema in my database. So I need not grant the SRW API.
And I don't find any package body in my database.
I think there may some problems in the installing script.
The script srwAPIins.sql includes the file srwcre.plb.
prompt ... D O N E - installing custom datatypes
prompt ... installing package SRW
But I could not find the file srwcre.plb in path <11ias_home>\reports\admin\sql\, I just could find the file srwcre_wrap.plb.
And I try to change the file name srwcre.plb of srwAPIins.sql to srwcre_wrap.plb.
Good news is the body of package appeared, but the bad is the body is error.
Did you meet this case before?
Or are there any other scripts should be run before this installing script?