Thread Rating:
  • 289 Vote(s) - 2.81 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Curl execute Oracle database procedure
04-21-2017, 11:18 AM,
#3
RE: Curl execute Oracle database procedure
(04-18-2017, 08:52 AM)tdeng Wrote: I don't think Curl' ConnectedRecordSet supports stored procedure.
To do this, you need to create your own ConnectedRecordSet together with a server-side program/API to help you execute such a database procedure.
I found the way to execute store procedure and function Oracle.

To execute Procedure:
Code:
{let rs:RecordSet=
    {connection.create-record-set "DATABASE_NAME", "call PROCEDURE_NAME()"}
}

I have tried procedure with update statement and it successful.

To call Function:
Code:
{let rs:RecordSet=
    {connection.create-record-set "DATABSE_NAME","SELECT FUNCTION_NAME() AS ABC FROM DUAL"}
}
{rs.load}

{for r:Record in rs do
    {outfmt {format "%s, ", r["ABC"]}}
}

It will show return value of function in CURL console.


Messages In This Thread
Curl execute Oracle database procedure - by NamDH - 04-14-2017, 11:38 AM
RE: Curl execute Oracle database procedure - by NamDH - 04-21-2017, 11:18 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')