Unanswered: output string of SP gets terminated ??whats the solution!!!
My quey in Delphi/Borland C++ Builder is -
I am using TStoredProc component to execute a stored procedure of oracle:
Procedure declaration is
Procedure OMM_GET_SWITCH_SETTINGS ( p_Return OUT varchar2,
p_Error_Return OUT varchar2,
p_Switch_type IN varchar2,
p_Agent_Code IN varchar2
Now the return value p_Return should returns 1000 characters, But on setting up everything in Borland env (Dlphi/Borland C++ Builder) , we get only 255 chars followed by lots of spaces and some junk values.
Question is why the output string gets terminated and what is the possible solution for this.
As such the procedure when executed on SQL prompt returns correct 1000 chars.