| The PL/SQL procedure that generates a PL/SQL document [message #170512] |
Thu, 04 May 2006 02:52  |
ying
Messages: 143
Registered: May 2002
|
Senior Member |
|
|
Hi,
I have been trying to generate a PL/SQL document and I have define an atribute of type Document so that the document is embedded inside an HTML representation of the notification as viewed from the Notification Web page, or the HTML
attachment to an e–mail message.
As refer to the Oracle Workflow Developer Guide, the standard API for generating the PL/SQL is as below:
procedure <procedure name>
(document_id in varchar2,
display_type in varchar2,
document in out varchar2,
document_type in out varchar2)
Question No 1.
But, I'm confused with the example given as mentioned below:
*************************************************************
For example, the following string represents the PL/SQL
document, po_req:2034, generated by the procedure
po_wf.show_req.
plsql:po_wf.show_req/po_req:2034
**************************************************************
To me it should be plsql:po_wf.show_req/docid001:text/html
as base on the standard API, it requires argument document_id and display_type, please advise.
Question No 2.
I tried to create my own procedure for generating PL/SQL document as per attachment and in my workflow process, I have an document type attribute which the value is pl/sql:CY_DOCUMENT.INFOR_A/doc_p:ch006
When I run the process, I get error message in my notification as below:
Error
3402: No valid session exists for this user. Please establish a new session through the login page.
Error Name: WFSEC_NO_SESSION
Error Stack:
Wf_Notification.GetAttrText(175564, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(175564, #ATTACHMENTS)
Wf_Notification.GetAttrText(175564, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(175564, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(175564, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178425, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178425, #ATTACHMENTS)
Wf_Notification.GetAttrText(178425, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(178425, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(178425, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178973, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178973, #ATTACHMENTS)
Wfa_Sec.GetSession()
fnd_document_management.get_launch_document_url(pl/sql:CY_DOCUMENT.INFOR_A/doc_p:ch007)
Wf_Notification.GetAttrDoc(178973, MYDOCUMENT, text/html)
pls advise...
|
|
|
|
|
|
| Re: The PL/SQL procedure that generates a PL/SQL document [message #177899 is a reply to message #170779] |
Sat, 17 June 2006 10:38  |
agostino_neto
Messages: 180
Registered: July 2005
|
Senior Member |
|
|
Question No 1:
Developer's Guide says default value should be:
plsql:<procedure>/<document identifier>
-> <document identifier> should identify the document.
For me you can pass any value but it is better to pass like in the example the name of the item type and the item key.
Question No 2:
Did you check your message attribute ? Try with these parameters
Type: Document
Source: Send
Frame Target: New Window
Attach Content: Checked
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
