Trying to call Oracle procedure from Lotus Notes
The procedure definition is as
p_sender varchar2 in
p_recipients varchar2 in
p_subject varchar2 in
p_message long in
p_priority binary_integer in
p_contenttype varchar2 in
WHEN I run this procedure from oracle and pass the required values it works fine
WHen this procedure is called from Lotus by passing the same values it doesent work
p_message parameter than it starts working from Lotus also
So can someone tell me if there is any size restriction on what can be passed to Long from Lotus script
Below is my code to call the procedure
Sub SendMailProc(P_Sender As String,P_Recipients As String,P_Subject As String,P_Message As Variant,P_ContentType As String)
On Error Goto ErrorHasOccurred
’ Set the stored procedure owner and stored procedure name.
glbDbConnection.Procedure = “LSIMAIL.SendMail”
Dim input_fieldlist As New LCFieldList
Dim in_field_text As New LCField (1, LCTYPE_TEXT)
Set in_field_text = input_fieldlist.Append (“P_Sender”, LCTYPE_TEXT)
in_field_text.Text = P_Sender
Set in_field_text = input_fieldlist.Append (“P_Recipients”, LCTYPE_TEXT)
in_field_text.Text = P_Recipients
Set in_field_text = input_fieldlist.Append (“P_Subject”, LCTYPE_TEXT)
in_field_text.Text = P_Subject
Set in_field_text = input_fieldlist.Append (“P_Message”, LCTYPE_TEXT)
'Call in_field_text.SetFormatStream (, 0, )
in_field_text.value = P_Message
Set in_field_text = input_fieldlist.Append (“P_Priority”, LCTYPE_INT)
in_field_text.Text = 1
Set in_field_text = input_fieldlist.Append (“P_ContentType”, LCTYPE_TEXT)
If P_ContentType=“H” Then
in_field_text.Text = “text/HTML”
Else
in_field_text.Text = “text/PLAIN”
End If
Call glbDbConnection.Call (input_fieldlist,1,Nothing)
Exit Sub
ErrorHasOccurred:
glbLogSubroutineStr = “agExternalAppraisal:SendMailProc”
glbLogEntryDocScreenStr = glbCurrentNotesDoc.BusinessScreenName(0)
Call GenerateErrorLog(glbLogSubroutineStr,glbLogEntryDocScreenStr)
End Sub
thanks in advance