OraFAQ Forum: Forms » How to call a back-end procedure having clob as arguments

Home » Developer & Programmer » Forms » How to call a back-end procedure having clob as arguments

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

How to call a back-end procedure having clob as arguments [message #126255]

Sat, 02 July 2005 01:44

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

hi all,
I have a back-end procedure as below:
procedure test_clob(p_clob in out clob) as
-----
-----
end;

I am calling this procedure from a button click on a form.
When i click the button the form get disappeared.But if i comment the calling to the back-end procedure test_clob,it work fine.
What can be the reason.
I had compiled the form.And also checked that the button is in the canvas.

Can form call a back-end procedure having one argument as clob.

Please reply.

Thanks
Dinesh Cool

Report message to a moderator

Re: How to call a back-end procedure having clob as arguments [message #126614 is a reply to message #126255]

Tue, 05 July 2005 23:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What versions of Forms and Database are you running?

David

Report message to a moderator

Re: How to call a back-end procedure having clob as arguments [message #127025 is a reply to message #126614]

Thu, 07 July 2005 23:13

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Hi david,
I am using Form 6i and oracle 9i.

Pls reply back..

Thanks
Dinesh

Report message to a moderator

Re: How to call a back-end procedure having clob as arguments [message #127032 is a reply to message #127025]

Fri, 08 July 2005 01:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you make it work if you use a parameter of varchar2?

I am confident that Forms 6 and/or Oracle 7/8 did not support CLOB as a parameter type.

Try getting it to work with another data type and also add more error handling.

Are you using the correct CLOB-type functions in the procedure? Can you get the procedure to write to a file so that you can see at which statement it fails?

David

[Updated on: Fri, 08 July 2005 01:17]

Report message to a moderator

Re: How to call a back-end procedure having clob as arguments [message #128005 is a reply to message #127032]

Thu, 14 July 2005 09:44

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Thanks david,
any way we can't a method call wit CLOB as argument in form 6

With regards
Dinesh

Report message to a moderator

Previous Topic:	Designer6r4 install!
Next Topic:	Dynamically change the size of text/display field thru mouse pointer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 03:50:23 CST 2025