Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved datawindow procedure return value

  1. Issue
0
Votes
Undo
  1. Emilio Centeno
    Emilio Centeno
  2. PowerBuilder
  3. Thursday, 27 July 2017 02:01 AM UTC

Buen dia. 

Tengo un Datawindow con un Procedure (ORACLE) asociado para hacer un insert. Este Procedure me devuelve un dato en el datawindow. 

La aplicacion funciona correctamente en escritorio pero en WEB me sale un error:

"ORA-06553: PLS-306: número o tipos de argumentos erróneos al llamar a 'SP_INS_DOCUMENTO

No changes made to database."

call  PKG_QPT.SP_INS_DOCUMENTO( NULL , '011', 'prueba rfi web correo',  NULL ,  NULL , 
 NULL , to_timestamp('2017-07-27 00.00.00.000000','yyyy-mm-dd hh24:mi:ss.ff'), 'SST',
  'DP1', 'HTD', 'HTN1', 'COS-RFI-064', 'Cod-065', 'des', '3014',
   NULL , 'ref',  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 'F',  NULL ,  NULL ,  NULL ,
     NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 
      NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,
        NULL , 27, '', '',  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 4,
         NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 
          NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , '009');

 

No se si los DATAWINDOWS con Procedure esten soportados en WEB de APPEON.

 

Atte

E.C

  1. DataWindow
  2. Oracle
Dynamic loaded fonts not included in NativePDF!
Enhancement request to improve Browser Window
Responses (2)
Appeon Support Team
Appeon Support Team Accepted Answer Pending Moderation
  1. Thursday, 3 August 2017 07:39 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

Please don't pass number as string or pass string as number, and please provide a simple PB case and SQL to create stored procedure to us for more study, thanks.

Regards,
Appeon Support

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 2 August 2017 16:09 PM UTC
  2. PowerBuilder
  3. # 2

Hi

The Oracle error you are getting from the procedure is saying that the datatypes of the parameters you are passing do not match or you have some missing. Check the datatypes in the oracle procedure definition and then chek what is n the datawindow.

Goole translate to spanish:

El error de Oracle que está recibiendo del procedimiento está diciendo que los tipos de datos de los parámetros que está pasando no coinciden o que faltan algunos. Compruebe los tipos de datos en la definición del procedimiento de Oracle y luego chek lo que es n la ventana de datawindow.

Hope that helps

David

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.