Thread Rating:
  • 183 Vote(s) - 2.73 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Curl execute Oracle database procedure
04-14-2017, 11:38 AM, (This post was last modified: 04-14-2017, 04:38 PM by NamDH.)
#1
Curl execute Oracle database procedure
Hello.

I already have:
- Curl sample connected to Oracle database.
- Oracle database have some procedure and function.

Let's assume I created procedure in Oracle name PR_SELECT_DATA:
Code:
CREATE PROCEDURE PR_SELECT_DATA (TOTAL_RECORD OUT NUMBER) AS    
    BEGIN
        SELECT
            COUNT(*)    
        INTO
            TOTAL_RECORD
        FROM
            TOP_SALES_CUSTOMERS;    
    END;
/


Now I want to execute this procedure in Curl code, I expect something like:
Code:
connection.executeProcedure("PR_SELECT_DATA ");
connection.executeFunction("FUNCTION_NAME ");

I have tried:
Code:
{let statement:String =
     {
        String
            "DECLARE TOTAL_RECORD NUMBER;"         , "BEGIN        PR_SELECT_DATA (TOTAL_RECORD);        END;" }
}
{connection.execute "SH", statement}
but no luck.

I searched in this forum, no luck again.
Can anyone help me?
Reply


Messages In This Thread
Curl execute Oracle database procedure - by NamDH - 04-14-2017, 11:38 AM

Possibly Related Threads...
Thread Author Replies Views Last Post
  TLS通信下でCould not deserialize the object from Curl.発生 MIT 3 4,767 03-10-2017, 08:35 AM
Last Post: MIT
  Protecting SSL private key in a Curl script aensys 1 2,363 02-10-2017, 02:02 PM
Last Post: heavybugtracker
  curl library 7.36.0: curl_easy_perform() function call failed when used for getting a joezhao 1 3,632 10-19-2016, 09:41 AM
Last Post: dyoshida
  Curl IDE からのランチャが見つかりません umemura 1 3,771 06-30-2016, 10:12 AM
Last Post: umemura
  Curl RTE Install smtit 1 2,738 05-06-2016, 12:36 PM
Last Post: dice256
  Curl RTE Command line smtit 1 2,917 04-19-2016, 09:35 AM
Last Post: dice256
  What OS that CURL can support for deloyment? tiennv 1 4,574 08-22-2015, 02:12 AM
Last Post: tdeng
  Curl RTEのPPAPIプラグインについて でり 1 4,398 06-09-2015, 11:03 AM
Last Post: でり
  cURL Client app Michael-2015 1 3,852 04-16-2015, 12:27 PM
Last Post: dyoshida
  Could not deserialize the object from Curl. umemura 4 6,641 04-11-2015, 04:45 AM
Last Post: Sumerjobs
Forum Jump:


Users browsing this thread:
1 Guest(s)

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1017 - Can't find file: 'mybb_threadviews' (errno: 2)
Query:
INSERT INTO mybb_threadviews (tid) VALUES('1447')