Home » Developer & Programmer » Forms » Package call shows error in 10g.
Package call shows error in 10g. [message #209264] Thu, 14 December 2006 00:31 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi friends,
I have a form developed in forms 6i which is working fine.
But when I migrated that to 10g it does not compile.In a package call it shows an error .
(Error : Implementation restriction ADT or schema level collection not supported at client side with non-OCI mode).

This is the function call...
l_status := pay.CreateServiceItem(l_srvc(i).service,
	    src_org_id,
	    aps.gr_val.appn_num,
            accountnum,
            dest_org_id,
	    null,
            :control_block.app_cycle,
            aps.g_operator_id,
            :control_block.dt_received);

Here the Null parameter is a type and its default value is NULL.

If I comment the whole package call the forms runs successfully.

Can anyone suggests me what would be the cause for this.

Regards,
Marlon

Upd-Mod: Please put 'code' tags around code, and you don't have to press 'enter' at the end of each line. Thoughful formatting makes easier reading and faster answering.

[Updated on: Thu, 14 December 2006 00:59] by Moderator

Report message to a moderator

Re: Package call shows error in 10g. [message #209270 is a reply to message #209264] Thu, 14 December 2006 00:41 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check these.
Might help you.
Oracle Forum
ORAFAQ
By
Vamsi
Re: Package call shows error in 10g. [message #209277 is a reply to message #209264] Thu, 14 December 2006 01:01 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the datatype of the parameter through which you are passing 'null'? If numeric then try 'to_number(null)', if character then try 'to_char(null)', if date then try 'to_date(null)'.

Get back to us please.

David
Re: Package call shows error in 10g. [message #209279 is a reply to message #209264] Thu, 14 December 2006 01:04 Go to previous messageGo to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
The parameter value NULL raises error here but when i remove this also it shows the same error.NULL is a TYPE datatype.

when I pass the values using named notation also the same error I get.


Regards,
Marlon.
Re: Package call shows error in 10g. [message #209304 is a reply to message #209279] Thu, 14 December 2006 03:24 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
reported

By: marlon_loyolite
On: Thu, 14 December 2006 10:10
In: Developer & Programmer Forms Package call shows error in 10g.
Reason Can anyone suggests me a solution for this problem.


Don't report messages to get attention. Moderators are the only ones to see reports.

MHE
Re: Package call shows error in 10g. [message #209774 is a reply to message #209304] Sun, 17 December 2006 19:46 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please confirm that this code works in Forms 6i and that you have not changed the code in 'pay.CreateServiceItem' for 10g.

Please post the error number that you are receiving.

David
Previous Topic: problem related to property class
Next Topic: whats wrong with this code?
Goto Forum:
  


Current Time: Sat Dec 10 08:58:11 CST 2016

Total time taken to generate the page: 0.21397 seconds