| Oracle 8i User written Function calls from another package [message #75389] |
Mon, 04 August 2003 23:37  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
