Re: DBMS Pipes - redux
Date: 30 Aug 1994 16:10:53 GMT
Message-ID: <33vlmd$imm_at_dcsun4.us.oracle.com>
In article <33vbcl$8vn_at_news-feed-1.PeachNet.EDU>, John Morgan <John_Morgan_at_OIT.PeachNet.EDU> writes:
|> OK- I have (sort of) created a Pro-C program to use DBMS pipes. When I
|> compile with SQLCHECK=SEMANTICS, I get the following:
|> PCC-S-0061: Error at line 38, column 24. PLS-201: identifier
|> 'SYS.DBMS_PIPE' must be declared
|>
|> this is on the end-exec line.
|>
|> It gives me an error for each DBMS_PIPE call.
|>
|> It still compiles, but I'm having problems that I believe are related to
|> this.
|>
|> Any ideas??
You need to also include the USERID precompiler option. When SQLCHECK=SEMANTICS, the precompiler will attempt to connect to the database during the precompile to verify that the objects you reference (tables, procedures, etc.) actually exist and you have permissions on them. USERID=scott/tiger, for example. scott would also need to have execute privileges on the DBMS_PIPE package as well. Received on Tue Aug 30 1994 - 18:10:53 CEST