Re: An error occurred while the cartridge performed authorization check.

On Mon, 10 Nov 1997 17:21:57 -0000, "chris neale" <chrisn_at_mercia.com> wrote:

>I am using oracle web server 3.0
>Can anyone tell me what would cause this error?
>
>also what is the format for accesssing packages
>
>http://site:port/x/y
>
>where x and y are what, (listener,plsql agent name, dad name)?

I have encountered this error message only yesterday. In our case it was because the SQL*NET v2 service was not running, so that when the system tried to contact the database, it couldn't, and decided that this was because of an authorization failure. So, best check that SQL*Net is running first (ie the listener etc.). If that desn't work, check that the username and passwords in the DAD and SQL Cartridge are correct and have execute priviledges for the package.procedure you wish to run.

The correct format for a call is :-

http://site:port/Cartridgename/plsql/plsqlprocedure_name

so if your cartridge was called app1 and the procedure name was Do_Something in a package called Pack1and it was at site 9.9.9.9 on port 7777 then you would call :-

http://9.9.9.9:7777/app1/plsql/Pack1.Do_Something

you can further complicate this if you wish to use a procedure owned by another user in the db by specifying their name, ie user could be Oracle1

http://9.9.9.9:7777/app1/plsql/Oracle1.Pack1.Do_Something

The DAD which you wish to use is defined within the PLSQL cartidge which you are using.

Hope this helps

Laurence
All views expressed are my own
and carry no guaruntees.
Believe them at your own risk. Received on Tue Nov 11 1997 - 00:00:00 CST