Home » Server Options » Replication » Oracle 8i User written Function calls from another package
Oracle 8i User written Function calls from another package [message #75389] Mon, 04 August 2003 23:37 Go to next message
R.Abiram
Messages: 1
Registered: August 2003
Junior Member
Hi,

I have two packages both of them written by me
1)hello.sql
2)world.sql

hello.sql conatins
The package hello has two function
with
1) openQueue(qname in varchar2 ,host in varchar2)
2) closeQueue(qname in varchar2 ,host in varchar2)

Clearly defined in hello package
My hello.sql compiles succesfully without any error.

I call hello.openQueue & hello.closeQueue in world.sql ie
world package

In world package in one of the world package function as I call hello function as follows.

----
------
hello.openQueue('QUEUE2','xxx.yyy.zzz');
hello.closeQueue('QUEUE2','xxx.yyy.zzz');
-------
----

But I always get the error in sqlplus when I call the hello function from world package as shown below

SQL> @world.sql

Package created.

No errors.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY WORLD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
13/1 PLS-00221: 'OPENQUEUE' is not a procedure or is undefined
13/1 PL/SQL: Statement ignored
15/1 PLS-00221: 'CLOSEQUEUE' is not a procedure or is undefined
15/1 PL/SQL: Statement ignored
SQL>

I even tried adding the package.function@dblink but no use

I doubt the way I call the funtion from world package if there any other way please let me know.

Regards,
Abiram
Re: Oracle 8i User written Function calls from another package [message #75499 is a reply to message #75389] Thu, 06 May 2004 19:39 Go to previous message
Stirling
Messages: 1
Registered: May 2004
Junior Member
me thinks it is expecting a procedure not a function.

If you do something with the hello... call it should work, but you can't just have a function by itself like that. stick a htp.p() around it or something...
Previous Topic: replication pack. error
Next Topic: snapshot & materialised view in 9i
Goto Forum:
  


Current Time: Sat Apr 19 06:08:28 CDT 2014

Total time taken to generate the page: 0.18323 seconds