Styjun

Scam? Checks via Email

Why were contact sensors put on three of the Lunar Module's four legs? Did they ever bend and stick out sideways?

How should I quote American English speakers in a British English essay?

Is it unprofessional to mention your cover letter and resume are best viewed in Chrome?

GNU sort stable sort when sort does not know sort order

Tikzpicture doesn't display correctly

Summoning A Technology Based Demon

What is the German equivalent of the proverb 水清ければ魚棲まず (if the water is clear, fish won't live there)?

Piece of chess engine, which accomplishes move generation

Why was the LRV's speed gauge displaying metric units?

Why is my fluorescent tube orange on one side, white on the other and dark in the middle?

Why would a personal invisible shield be necessary?

Complaints from (junior) developers against solution architects: how can we show the benefits of our work and improve relationships?

How does a poisoned arrow combine with the spell Conjure Barrage?

Just how much information should you share with a former client?

Why put copper in between battery contacts and clamps?

Move DB/LOG files - Detach/Attach - Problem

GNU GPL V3 with no code change disclosure

Rampant sharing of authorship among colleagues in the name of "collaboration". Is not taking part in it a death knell for a future in academia?

How can Paypal know my card is being used in another account?

Why did I lose on time with 3 pawns vs Knight. Shouldn't it be a draw?

Why force the nose of 737 Max down in the first place?

What are the cons of stateless password generators?

Is there an antonym(a complementary antonym) for "spicy" or "hot" regarding food (I DO NOT mean "seasoned" but "hot")?

Executing an Oracle stored procedure with a output parameter of an array of complex type using PHP oci driver

Preferred method to store PHP arrays (json_encode vs serialize)Execute stored procedure with an Output parameter?ORA-06550, PLS-00306; Error inserting data to Oracle procedureIs it possible to call stored Procedure from .net application passing list of Array of string or integer as parameterHow to call package from php having procedure in oracle using oci drivers?How to pass an array into a SQL Server stored procedureORACLE Stored Procedure in PHP processingHow to call stored procedure with parameter type AnyData?ORA-06502: PL/SQL: numeric or value error: character string buffer too small - Executing using OCI interfaceoci_execute(): ORA-06550: PLS-00306: wrong number or types of arguments

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have an Oracle procedure

create or replace PROCEDURE PREVISAO_CHEGADA(PONTO IN number, LINHA IN number, ROTA IN number, RETORNO OUT POSICAO_ONIBUS_TAB) IS ...

where out parameter POSICAO_ONIBUS_TAB is an array of POSICAO_ONIBUS
and POSICAO_ONIBUS is

create or replace TYPE POSICAO_ONIBUS AS OBJECT (LOGP_CODIGO NUMBER, VEIC_CODIGO NUMBER, PROX_VIAG VARCHAR2(5), distancia NUMBER);

I need to call this procedure with PHP, but I'm getting the error:

oci_execute(): ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PREVISAO_CHEGADA' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

follows PHP code below:

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA=(SID=mydb)))";
$conn = oci_connect("user", "password", $db, 'WE8ISO8859P1');
$sql = 'BEGIN previsao_chegada(:ponto, :linha, :rota, :retornos); END;';
$stmt = oci_parse($conn,$sql);
oci_bind_by_name($stmt,':ponto',$ponto,10);
oci_bind_by_name($stmt,':linha',$linha,10);
oci_bind_by_name($stmt,':rota',$rota,10);
oci_bind_array_by_name($stmt,':retornos',$retornos, 100, 100, SQLT_CHR);

$ponto = 391;
$linha = 280;
$rota = 0;
$retornos = array();

oci_execute($stmt);

php oracle stored-procedures out-parameters

share|improve this question

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

add a comment | 

0

I have an Oracle procedure

create or replace PROCEDURE PREVISAO_CHEGADA(PONTO IN number, LINHA IN number, ROTA IN number, RETORNO OUT POSICAO_ONIBUS_TAB) IS ...

where out parameter POSICAO_ONIBUS_TAB is an array of POSICAO_ONIBUS
and POSICAO_ONIBUS is

create or replace TYPE POSICAO_ONIBUS AS OBJECT (LOGP_CODIGO NUMBER, VEIC_CODIGO NUMBER, PROX_VIAG VARCHAR2(5), distancia NUMBER);

I need to call this procedure with PHP, but I'm getting the error:

oci_execute(): ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PREVISAO_CHEGADA' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

follows PHP code below:

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA=(SID=mydb)))";
$conn = oci_connect("user", "password", $db, 'WE8ISO8859P1');
$sql = 'BEGIN previsao_chegada(:ponto, :linha, :rota, :retornos); END;';
$stmt = oci_parse($conn,$sql);
oci_bind_by_name($stmt,':ponto',$ponto,10);
oci_bind_by_name($stmt,':linha',$linha,10);
oci_bind_by_name($stmt,':rota',$rota,10);
oci_bind_array_by_name($stmt,':retornos',$retornos, 100, 100, SQLT_CHR);

$ponto = 391;
$linha = 280;
$rota = 0;
$retornos = array();

oci_execute($stmt);

php oracle stored-procedures out-parameters

share|improve this question

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

add a comment | 

I have an Oracle procedure

create or replace PROCEDURE PREVISAO_CHEGADA(PONTO IN number, LINHA IN number, ROTA IN number, RETORNO OUT POSICAO_ONIBUS_TAB) IS ...

where out parameter POSICAO_ONIBUS_TAB is an array of POSICAO_ONIBUS
and POSICAO_ONIBUS is

create or replace TYPE POSICAO_ONIBUS AS OBJECT (LOGP_CODIGO NUMBER, VEIC_CODIGO NUMBER, PROX_VIAG VARCHAR2(5), distancia NUMBER);

I need to call this procedure with PHP, but I'm getting the error:

oci_execute(): ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PREVISAO_CHEGADA' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

follows PHP code below:

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA=(SID=mydb)))";
$conn = oci_connect("user", "password", $db, 'WE8ISO8859P1');
$sql = 'BEGIN previsao_chegada(:ponto, :linha, :rota, :retornos); END;';
$stmt = oci_parse($conn,$sql);
oci_bind_by_name($stmt,':ponto',$ponto,10);
oci_bind_by_name($stmt,':linha',$linha,10);
oci_bind_by_name($stmt,':rota',$rota,10);
oci_bind_array_by_name($stmt,':retornos',$retornos, 100, 100, SQLT_CHR);

$ponto = 391;
$linha = 280;
$rota = 0;
$retornos = array();

oci_execute($stmt);

php oracle stored-procedures out-parameters

share|improve this question

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

create or replace PROCEDURE PREVISAO_CHEGADA(PONTO IN number, LINHA IN number, ROTA IN number, RETORNO OUT POSICAO_ONIBUS_TAB) IS ...

create or replace TYPE POSICAO_ONIBUS AS OBJECT (LOGP_CODIGO NUMBER, VEIC_CODIGO NUMBER, PROX_VIAG VARCHAR2(5), distancia NUMBER);

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA=(SID=mydb)))";
$conn = oci_connect("user", "password", $db, 'WE8ISO8859P1');
$sql = 'BEGIN previsao_chegada(:ponto, :linha, :rota, :retornos); END;';
$stmt = oci_parse($conn,$sql);
oci_bind_by_name($stmt,':ponto',$ponto,10);
oci_bind_by_name($stmt,':linha',$linha,10);
oci_bind_by_name($stmt,':rota',$rota,10);
oci_bind_array_by_name($stmt,':retornos',$retornos, 100, 100, SQLT_CHR);

$ponto = 391;
$linha = 280;
$rota = 0;
$retornos = array();

oci_execute($stmt);

share|improve this question

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

share|improve this question

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges

asked Mar 26 at 20:28

Gustavo de FreitasGustavo de Freitas

1766 bronze badges