Home » SQL & PL/SQL » SQL & PL/SQL » (very Urgent)calling Index-by table
(very Urgent)calling Index-by table [message #7571] Mon, 23 June 2003 00:43 Go to next message
Naveen
Messages: 75
Registered: June 2001
Member
Hi,
i have created a collection type of index-by table in a package. My package is working fine and returning the tresults. The problem is that our java developers when they are trying to register the out parameter for the result set they are getting error. They are not able to refer to the index-by table type. They are getting invalid name pattern error. I told them to use packagename.type. Still there is no luck. Could someone help me.

Thank you.
Naveen

Report message to a moderator

Re: (very Urgent)calling Index-by table [message #7603 is a reply to message #7571] Tue, 24 June 2003 12:53 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You need to base the parameter on a defined SQL type (create or replace type ...), not a PL/SQL type:

Report message to a moderator

Previous Topic: add_months giving problem
Next Topic: Transposition SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:06:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.