Home » Applications » Oracle Fusion Apps & E-Business Suite » Execute Procedure using Forms Personalization (12.0)
Execute Procedure using Forms Personalization (12.0) [message #580067] Tue, 19 March 2013 17:16 Go to next message
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 .
Re: Execute Procedure using Forms Personalization (12.0) [message #580074 is a reply to message #580067] Wed, 20 March 2013 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Execute Procedure using Forms Personalization (12.0) [message #580079 is a reply to message #580074] Wed, 20 March 2013 01:22 Go to previous messageGo to next message
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 .
Re: Execute Procedure using Forms Personalization (12.0) [message #580084 is a reply to message #580079] Wed, 20 March 2013 01:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Execute Procedure using Forms Personalization (12.0) [message #580085 is a reply to message #580084] Wed, 20 March 2013 02:27 Go to previous messageGo to next message
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 .......
Re: Execute Procedure using Forms Personalization (12.0) [message #580092 is a reply to message #580085] Wed, 20 March 2013 05:47 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh well ... never mind, I'm glad you fixed it.
Previous Topic: APP-PO-14142 : get_po_prameters-10
Next Topic: column named " Stock Number"
Goto Forum:
  


Current Time: Fri Mar 29 03:10:17 CDT 2024