6 Replies Latest reply: Apr 5, 2012 8:45 PM by 853124 RSS

    SRW install

    853124
      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
          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
            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
              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
                Thanks a lot.
                I will try again.

                Edited by: 850121 on 2012-3-26 下午6:28
                • 5. Re: SRW install
                  IK
                  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
                    Thanks for you reply.
                    I try and meet the compiled error.

                    Maybe some environment problem.

                    Thanks all the same.