This discussion is archived
6 Replies Latest reply: Apr 5, 2012 6:45 PM by 853124 RSS

SRW install

853124 Newbie
Currently Being Moderated
Hi all,

I'm new to Oracle Report.

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
AS
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
BEGIN
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
srw.add_parameter(myPlist,'GATEWAY','http://.../reports/rwservlet');
srw.add_parameter(myPlist,'REPORT','TheFirstReport.rdf');
srw.add_parameter(myPlist,'USERID','adf01/adf01@test');
srw.add_parameter(myPlist,'DESFORMAT','pdf');
srw.add_parameter(myPlist,'DESTYPE','file');
srw.add_parameter(myPlist,'DESNAME','D:\shared\temp\test.pdf');
myIdent := srw.run_report(myPlist);
END PROCEDURE_TEST_REPORT;
/

Look forward to your reply.

Thanks a lot.

Edited by: 850121 on 2012-3-22 上午3:32
  • 1. Re: SRW install
    InoL Guru
    Currently Being Moderated
    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.

    See http://docs.oracle.com/cd/E21764_01/bi.1111/b32121/pbr_evnt001.htm#i1007523:
    "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."
  • 2. Re: SRW install
    853124 Newbie
    Currently Being Moderated
    Hi InoL,

    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
    prompt
    prompt ... installing package SRW

    @srwcre.sql
    @srwcre.plb
    ...

    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.

    Thanks
  • 3. Re: SRW install
    InoL Guru
    Currently Being Moderated
    It should be as easy as what you describe (just run the install script).
    However, I cannot confirm that the installation script for 11g has an error. I have the 10g version, which runs just fine.
  • 4. Re: SRW install
    853124 Newbie
    Currently Being Moderated
    Thanks a lot.
    I will try again.

    Edited by: 850121 on 2012-3-26 下午6:28
  • 5. Re: SRW install
    IK Newbie
    Currently Being Moderated
    Hello...

    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

    @?/reports/admin/sql/srwcre.sql
    @?/reports/admin/sql/srwcre.plb

    Save it.

    3. connect with ur user to sql plus and give command
    sql>@?/reports/admin/sql/srwAPIins.sql

    4.Portal user as ...your user/schema ...i.e abc@orcl (not the sys user).

    Check it ..this might help u..

    Regards,
    IK
  • 6. Re: SRW install
    853124 Newbie
    Currently Being Moderated
    Thanks for you reply.
    I try and meet the compiled error.

    Maybe some environment problem.

    Thanks all the same.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points