OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Execute Procedure using Forms Personalization (12.0)

Home » Applications » Oracle Fusion Apps & E-Business Suite » Execute Procedure using Forms Personalization (12.0)

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

Execute Procedure using Forms Personalization (12.0) [message #580067]

Tue, 19 March 2013 17:16

aljabali
Messages: 53
Registered: July 2008

Member

when i am Execute Procedure using Forms Personalization

='BEGIN
xx_prc('''||${item.USER.USER_NAME.value}||''','''||${item.USER_RESP.RESPONSIBILITY_NAME.value}||''');
END'

i have error ( could not be evaluated because of error ) why ?????

my procedure :

create or replace procedure xx_prc(v_user varchar2 , v_resp varchar2 )

is

v_val varchar2(10);
begin

insert into xx_prc_tbl
values (v_user ,v_resp) ;

commit;
end;

Can you Help me .

Report message to a moderator

Re: Execute Procedure using Forms Personalization (12.0) [message #580074 is a reply to message #580067]

Wed, 20 March 2013 00:09

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

Senior Member
Account Moderator

Quote:

i have error ( could not be evaluated because of error )

Which error is it?

Report message to a moderator

Re: Execute Procedure using Forms Personalization (12.0) [message #580079 is a reply to message #580074]

Wed, 20 March 2013 01:22

aljabali
Messages: 53
Registered: July 2008

Member

Thanks Sir for replay , this Error ( could not be evaluated because of error ) , Where the problem ?????????

please help me .

Report message to a moderator

Re: Execute Procedure using Forms Personalization (12.0) [message #580084 is a reply to message #580079]

Wed, 20 March 2013 01:51

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

Senior Member
Account Moderator

If "could not be evaluated because of error" is all you have, I'm sorry, but I have no idea. I was hoping that you got one (or several) ORA-xxxxx or FRM-xxxxx errors which would be more descriptive. As that's not the case, I wouldn't know what to say.

Procedure seems to be OK; if XX_PRC_TBL contains two columns whose datatypes match the ones you pass to the procedure, it *should* work correctly. Therefore, I suspect that the first part of code (the BEGIN - END block) might be causing problems.

I'm not familiar with EBS so I can't tell whether such a syntax is correct or not. Hopefully, someone else will be able to verify it.

Report message to a moderator

Re: Execute Procedure using Forms Personalization (12.0) [message #580085 is a reply to message #580084]

Wed, 20 March 2013 02:27

aljabali
Messages: 53
Registered: July 2008

Member

Dear Sir ,

Thanks for Reply ,

Yes , I not have any Error code message only i have "could not be evaluated because of error" ,

I was Surprised Because My problem is resolved when I am restart the server .

Thank you .......

Report message to a moderator

Re: Execute Procedure using Forms Personalization (12.0) [message #580092 is a reply to message #580085]

Wed, 20 March 2013 05:47

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

Senior Member
Account Moderator

Oh well ... never mind, I'm glad you fixed it.

Report message to a moderator

Previous Topic:	APP-PO-14142 : get_po_prameters-10
Next Topic:	column named " Stock Number"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:53:20 CST 2024