for not closing it directly.
Thanks again for your help as always
Dylan
On Sun, Jan 30, 2022, 18:39 Jeremy Evans wrote:
>
> On Sun, Jan 30, 2022 at 1:47 AM Dylan Camilleri wrote:
>
>> Hi,
>>
>> Want to add some notes. Did some further reading on the issue. If a jdbc
>&
true)
>
>
> I think we may have also bumped cursors at some point:
>
> ALTER SYSTEM SET OPEN_CURSORS = 400 SCOPE=BOTH;
>
>
> Hope this helps.
>
>
>
> On Fri, Jan 28, 2022 at 12:42 PM Jeremy Evans
> wrote:
>
>> On Fri, Jan 28, 2022 at 12:54 AM Dylan
Hi Jeremy!
I am encountering this error using sequel with jdbc connected to oracle. Is
there a way I can commit / control the amount of open cursors?
Caused by:
oracle.jdbc.OracleDatabaseException: ORA-01000: maximum open cursors
exceeded
With best regards,
Dylan!
--
You received this
rID = cs.getString(1)
puts newCustomerID
end
On Wednesday, October 27, 2021 at 5:06:25 PM UTC+2 Dylan Camilleri wrote:
> Thank you Jeremy,
>
> I am getting this if I switch to :select
>
> Sequel::DatabaseError: Java::JavaSql::SQLException: Cannot perform
Thanks,
Dylan
On Wednesday, October 27, 2021 at 4:28:36 PM UTC+2 Jeremy Evans wrote:
> On Wed, Oct 27, 2021 at 5:43 AM Dylan Camilleri wrote:
>
>> An update:
>>
>> This works and executes the procedure and "creates the customer"
>>
>> o
pStatus NUMBER ,
pCustomerNo VARCHAR2 ,
pPassword VARCHAR2 DEFAULT NULL)
On Wednesday, October 27, 2021 at 2:24:13 PM UTC+2 Dylan Camilleri wrote:
> Hi :)
>
> This is my first question in the forum. I would like to know the proper
> way to execute an oracle s
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 =