Home » Developer & Programmer » Forms » get error wilth DLL in forms and ora-06503 (merged)
icon9.gif  get error wilth DLL in forms and ora-06503 (merged) [message #239632] Tue, 22 May 2007 18:02 Go to next message
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
ora-06503 [message #240174 is a reply to message #239632] Thu, 24 May 2007 05:34 Go to previous messageGo to next message
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 232 times)
Re: ora-06503 [message #240222 is a reply to message #240174] Thu, 24 May 2007 07:09 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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.
Re: ora-06503 [message #240982 is a reply to message #240174] Mon, 28 May 2007 02:21 Go to previous message
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.
Previous Topic: LOV
Next Topic: Calling Form from Report
Goto Forum:
  


Current Time: Mon Dec 05 23:57:14 CST 2016

Total time taken to generate the page: 0.08459 seconds