Re: Help: error message ORA-06554, why?

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/03
Message-ID: <5d4m3p$d9q$2@newton.pacific.net.sg>#1/1

"YNLONG" <msgh_at_ms1.hinet.net> wrote:
>I run a PL/SQL like below:
>
>Create Or Replace Function GetExamNo (pExam_date in date,pSick_cal......
>.................
>
>but SQL/PLUS return a error message like below:
>
>ORA-06554: package DBMS_STANDARD must be created
>before using PL/SQL.
>
>but I had been run the SQL script DBMSSTDX.SQL,
>Can anyone tell me why have the error message?
>
>Thank's!

Hi there,

I think you should issue EXECUTE privilege of that procedure to user public before executing your statement.

Regards

N.Prabhakar Received on Mon Feb 03 1997 - 00:00:00 CST