I'm calling an Oracle stored procedure that returns two parameters, a CLOB and a BLOB:
Any ideas how to do this?
Hi Khalil,
https://success.outsystems.com/Documentation/Best_Practices/Performance_and_Monitoring/Performance_Top_10_Rules
Refer to below posts: https://www.outsystems.com/forums/discussion/39802/maximum-size-for-text-data-type/
https://www.outsystems.com/forums/discussion/9877/how-to-store-max-data-in-one-field/
Thanks, Aadhavan S
Thank you but I'm not concerned about performance or storing LOBs. My question is how to return them as output parameters when calling an Oracle stored procedure.
The first error is happening in the Oracle database, so can you ask help for some DBA?
The second one, I recommend check the data coming from the database and if it is ok, check the parse data in the C# code.
The procedure works well on it's own. But when called from OutSystems, TEXT type does not correctly represent a CLOB, and BINARY type does not correctly represent a BLOB.
Hello, Khalil!
Do you found some solution for your problem? Im in the same problem.
I'm sorry I didn't find a solution. I couldn't use a BLOB parameter and I had to modify the application to use smaller CLOBs.
Hello Khali, thanks for answers.
I'm already using clobs but I still with problem to use the connector. I used it in a less complex procedure (3 number in, 2 varchar out) and its works well, but now I'm trying to use it in a other procedure and it dont works, I'm having some oracle error (I did a lot of testes).
The procedure have this param:
PROCEDURE pr_gama_entidade(
p_useruid IN NUMBER ,
p_id_entidade IN NUMBER ,
p_id_gama_entidade IN OUT NUMBER,
p_data_atribuicao IN DATE ,
p_lim_inf IN VARCHAR2,
p_lim_sup IN VARCHAR2 ,
p_mng_type IN VARCHAR2,
p_status OUT NUMBER ,
p_insucessos OUT CLOB)
Structures: (P_INSUCESSOS_CLOB are defined with Type: Text)
Assign paramIn
But, when I call it, the response is:
{"Errors":["ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments in call to 'PR_GAMA_ENTIDADE'\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"],"StatusCode":500}
Could u see something wrong?
Returning here, I found the problem and its was caused by the parameter IN OUT, I change it for only OUT and its works... I'll check the component to try solve this problem in the source.
Thanks