Re: OAS: Unable to run the PL/SQL procedure

I would like to establish whether or not you can create a package with a stored procedure, then execute that stored procedure from the Sql*Plus window, so save the following to a file:

spool testpkg.lis
set SERVEROUTPUT ON
CREATE OR REPLACE PACKAGE testpkg
AS
  PROCEDURE test;
END testpkg;
/
CREATE OR REPLACE PACKAGE BODY testpkg
AS
    PROCEDURE test
    IS
    BEGIN
        DBMS_OUTPUT.PUT_LINE('yippie!');
    END test;
END testpkg;
/
show errors;
exec testpkg.test;
spool off;

Then submit it to Oracle with the following command:

start testpkg.sql

If it works then you have no trouble calling a stored procedure.  The samples are not completely self-contained and something may be missing, but this package doesn't depend on anything else.  Good luck.

Paul Cluiss
Dallas, Texas

George Wilson Mathias wrote:

 
Hello,

I had posted this query few days ago. I am posting it again since I did not find the proper solution.

I installed OAS4.0.7 on my NT machine. It has Oracle8i DB installed. OAS started up fine. But when I tried to run the sample PL/SQL programs, I got an error message :

  Can not service this request, please try again later

I had few error messages in a log file, they are:

10-18-1999 21:26:26 0          gmerlyn              `Auth Module` 127        4          0x80010    `OWS-06709: Domain scheme config section not found.  `

10-18-1999 21:26:26 0          gmerlyn              `Auth Module` 127        7          0x80001    `OWS-06702: Engine has been initialized.  `

10-18-1999 21:26:26 0          gmerlyn              `Auth Module` 127        7          0x80001    `OWS-06700: Client interface has been initialized.  `

10-18-1999 21:26:26 0          gmerlyn              `Cartridge Server` 127        4          0x400fff   `OWS-10852: Cartidge Server attempted to load an additional library
E:\Oracle\OAS407\ows\4.0\..\cartx\plsql\bin\ndwoa40.dll for cartridge DB_Utilities/DB_Browser  `

10-18-1999 21:26:27 0          gmerlyn              `Dispatcher` 369        1          0x2fff     `OWS-04517: Error indicated by
broker in getting cartridges of type DB_Utilities/DB_Browser.  `

10-18-1999 21:26:27 0          gmerlyn              `Dispatcher` 369        1          0x2fff     `OWS-04511: Error in grabbing
cartridge type DB_Utilities/DB_Browser from the subsystem.  `

10-18-1999 21:26:27 0          gmerlyn              `Dispatcher` 369        1          0x2fff     `OWS-04512: Request
E78789EB0100-79E5-E000-0100007F0171 has internal error due to Error 4511.  `
 

And by the way, what is Borker's status ?

Please help me here.

Thanks
George Mathias