laravel-oci8

laravel-oci8 copied to clipboard

Oci8 bindParam output parameter of type SQLT_NTY

3

### Summary of problem or feature request Hi guys, I'm using yajra/laravel-oci8 to connect with oracle database. The problem is when I call a package.procedure with parameters in/out. The result...

dbayona

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

5

I have problem laravel 8 and oracle 12C and php 7.4.8 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor service_name connect to laravel php code .env...

dome21117

Can't Rollback. Throws an error while deleting sequences

3

### Summary of problem or feature request I'm not able to run `php artisan migrate:rollback` or `php artisan migrate:fresh` cause it tries to drop sequences generated by the system. If...

jgrandon

creating inactive session with oracle database, which is overloading the server

2

### Summary of problem or feature request my database is on a different server from apache server with each request database, an active session is opened but this active session...

mukhtar9

Oracle 12

1

### Summary of problem or feature request ### Code snippet of problem ### System details - Operating System - PHP Version - Laravel Version - Laravel-OCI8 Version

dasun4u

Execute stored procedure with multiple cursors

5

### Summary of problem or feature request I have a stored procedures with more than one cursor two or even more and wonder how could I execute such a stored...

mhelaiwa

Failed to execute function executeFunction

2

### Summary of problem or feature request executeFunction Fails ``` Error Code : 6550\r\n Error Message : ORA-06550: line 1, column 18:\n PLS-00224: object 'BOOKING_MNT.CHECK_LOCATION_TIME(P_LOCATION, TO_DATE(P_DATE, DD-MM-YYYY HH24:MI))' must be...

mohkin

install without composer

2

### Summary of problem or feature request Due to an issue with security & firewall, I can use composer or git to install this module on laravel. Could you explain...

jebau

Output parameter - how to bind in oci8

4

### Summary of problem or feature request Would like to use Oracle Stored Procedure with output parameter SP: DECLARE out_var NUMBER; BEGIN test_params (1,2,out_var); DBMS_OUTPUT.PUT_LINE('Result:'||out_var); END call from Laravel: $procedureName...

pszemo

Can you help me, How to create a cursor from an array and pass it a cursor as an input parameter to a store procedure

1

What is required is this arrangement $cursorEntrada to convert it into a valid cursor to pass it to an oracle store procedure as an input parameter $cursorEntrada = [ 'MON_CONSULTAR'...

joseojedaf