This content has been marked as final. Show 6 replies
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?
Look forward to your reply.
I also has 10g version, its works fine...i do following steps
1. Copy report folder from ORAHOME_2 TO ORA_HOME_1
2. open file srwAPIins.sql from this directory in text editor and edit it as
3. connect with ur user to sql plus and give command
4.Portal user as ...your user/schema ...i.e abc@orcl (not the sys user).
Check it ..this might help u..