Questions tagged as 'toad'

I'm trying to run a Stored Procedure on Toad for Oracle 12.12 but I have not succeeded. I hardly execute the stored, I miss an error from the word Declare, I would appreciate your help. DECLARE -- Declarations var_P_NROTRA NUMBER;...

I have 1 table called 'CFACTURACOMISION' which has the columns. CLFILIAL, CLCLIENTE, CLASESOR, FOFACTURA, DACHAFACTURA, MNFACTURA, MNDESCUENTO MNIVA, MNTOTAL, FEVENCIMIENTO, CONDICIONESDEPAGO, PROMVENTA. The main objective of this table is...

I'm working with soap web services and trying to parse an xml with the oracle XMLtable command and inserting it into a table fails when the xml has many lines (2 million). It works well when the file has few lines. This is a summary of the comma...

I have a stored procedure ( SP1 ) that returns a cursor with many columns, I need to know how from another stored procedure ( SP2 ) I call SP1 strong> and the result manipulated it with a SELECT to group, add and do other kinds of thing...