OraFAQ Forum: Forms » get error wilth DLL in forms and ora-06503 (merged)

Home » Developer & Programmer » Forms » get error wilth DLL in forms and ora-06503 (merged)

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

get error wilth DLL in forms and ora-06503 (merged) [message #239632]

Tue, 22 May 2007 18:02

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

hi all

i have oracle 10g and windows xp pro .

i create DLL file by C# 2005 and use this dll file in forms.

i create form with button and when button pressed i pass number

variable to methed .

i get error

FRM 40735 when-button-pressed raised unhandled exception
ORA 304500 .

thax

Rafeek

Report message to a moderator

ora-06503 [message #240174 is a reply to message #239632]

Thu, 24 May 2007 05:34

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

hi all
i create dll by c#.
i use oracle 10g.
when i use function Ora_Ffi.Register_Function to register the function in dll file i get error
FRA-40735 when-button-pressed raised unhandled
exception ora-06503

thax
rafeek

Attachment: code.txt
(Size: 2.23KB, Downloaded 1306 times)

Report message to a moderator

Re: ora-06503 [message #240222 is a reply to message #240174]

Thu, 24 May 2007 07:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't write functions which do not return a value.

Quote:

ORA-06503: PL/SQL: Function returned without value

Cause: A call to PL/SQL function completed, but no RETURN statement was executed.

Action: Rewrite PL/SQL function, making sure that it always returns a value of a proper type.

Report message to a moderator

Re: ora-06503 [message #240982 is a reply to message #240174]

Mon, 28 May 2007 02:21

mustaf_82
Messages: 20
Registered: May 2007
Location: UAE

Junior Member

It is becoz of 2 problems;

1) Funtion is returning null.
2) The value which function is returning is exceeding the actual size limit of the variable.

Report message to a moderator

Previous Topic:	LOV
Next Topic:	Calling Form from Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 02:46:58 CST 2025