[image: photo_2021-10-28_01-52-51.jpg]
I run bin/console (irb) on my production server, it return false, thanks
在2021年10月27日星期三 UTC+8 上午2:41:08 写道:
> On Tue, Oct 26, 2021 at 10:56 AM Billy Zheng wrote:
>
>>
>> Thanks,
>>
>> i added this plugins, and test it on production, it still works.
>>
Hi Jeremy,
As per your suggestion. This works...
java_import "java.sql.Types"
java_import "oracle.jdbc.OracleTypes"
...
@@db.synchronize do |conn|
cs = conn.prepareCall('{call SpInsertCustomer(?, ?,?,?,?,?)}')
Thank you Jeremy,
I am getting this if I switch to :select
Sequel::DatabaseError: Java::JavaSql::SQLException: Cannot perform fetch on
a PLSQL statement: next
raise_error at
On Wed, Oct 27, 2021 at 5:43 AM Dylan Camilleri wrote:
> An update:
>
> This works and executes the procedure and "creates the customer"
>
> out_param = 0
> result =
> @@db.dataset.call_sproc(:update,"SpInsertCustomer",out_param,"Test
> Customer",99,18,2,"123456",nil)
>
> puts
An update:
This works and executes the procedure and "creates the customer"
out_param = 0
result =
@@db.dataset.call_sproc(:update,"SpInsertCustomer",out_param,"Test
Customer",99,18,2,"123456",nil)
puts out_param >> 0 (no change)
puts result >> nil (no return value)
Basically
Hi :)
This is my first question in the forum. I would like to know the proper way
to execute an oracle stored procedure with Sequel and get back the return
parameter from the procedure result into some variable.
These do not seem to work or even execute the procedure(no errors)
@@db =