OraFAQ Forum: Forms » Package call shows error in 10g.

Home » Developer & Programmer » Forms » Package call shows error in 10g.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Package call shows error in 10g. [message #209264]

Thu, 14 December 2006 00:31

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check these.
Might help you.
Oracle Forum
ORAFAQ
By
Vamsi

Report message to a moderator

Re: Package call shows error in 10g. [message #209277 is a reply to message #209264]

Thu, 14 December 2006 01:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Package call shows error in 10g. [message #209279 is a reply to message #209264]

Thu, 14 December 2006 01:04

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.

Report message to a moderator

Re: Package call shows error in 10g. [message #209304 is a reply to message #209279]

Thu, 14 December 2006 03:24

Maaher
Messages: 7065
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

Report message to a moderator

Re: Package call shows error in 10g. [message #209774 is a reply to message #209304]

Sun, 17 December 2006 19:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 06:57:04 CST 2024