donde esta el error?
Publicado por sara (8 intervenciones) el 08/07/2005 12:38:57
Hola tengo esto:
CREATE OR REPLACE PROCEDURE agregaEsquema (directorio IN varchar2,identificador IN varchar2,nombre IN varchar2,scr IN varchar2, exten IN varchar2, document IN varcahar2,autor IN varchar2 ) as
sc clob;
sc_file bfile;
ex blob;
ex_file bfile;
dc clob;
dc_file bfile;
BEGIN
sc_file := bfilename(directorio, scr);
ex_file := bfilename(directorio, exten);
dc_file := bfilename(directorio, document);
INSERT INTO ESQ_BD VALUES ( identificador, nombre, empty_clob(),empty_blob(),empty_clob(),autor)
RETURNING Script into sc,
RETURNING Extensional into ex,
RETURNING Docum into dc;
dbms_lob.fileopen(sc_file,dbms_lob.file_readonly);
dbms_lob.fileopen(ex_file,dbms_lob.file_readonly);
dbms_lob.fileopen(dc_file,dbms_lob.file_readonly);
dbms_lob.loadfromfile( sc, sc_file, dbms_lob.getlength (sc_file) );
dbms_lob.loadfromfile( ex, ex_file, dbms_lob.getlength (ex_file) );
dbms_lob.loadfromfile( dc, dc_file, dbms_lob.getlength (dc_file) );
dbms_lob.fileclose(sc_file);
dbms_lob.fileclose(ex_file);
dbms_lob.fileclose(dc_file);
commit;
END;
esto me da erro en el returning sabeis porque????
CREATE OR REPLACE PROCEDURE agregaEsquema (directorio IN varchar2,identificador IN varchar2,nombre IN varchar2,scr IN varchar2, exten IN varchar2, document IN varcahar2,autor IN varchar2 ) as
sc clob;
sc_file bfile;
ex blob;
ex_file bfile;
dc clob;
dc_file bfile;
BEGIN
sc_file := bfilename(directorio, scr);
ex_file := bfilename(directorio, exten);
dc_file := bfilename(directorio, document);
INSERT INTO ESQ_BD VALUES ( identificador, nombre, empty_clob(),empty_blob(),empty_clob(),autor)
RETURNING Script into sc,
RETURNING Extensional into ex,
RETURNING Docum into dc;
dbms_lob.fileopen(sc_file,dbms_lob.file_readonly);
dbms_lob.fileopen(ex_file,dbms_lob.file_readonly);
dbms_lob.fileopen(dc_file,dbms_lob.file_readonly);
dbms_lob.loadfromfile( sc, sc_file, dbms_lob.getlength (sc_file) );
dbms_lob.loadfromfile( ex, ex_file, dbms_lob.getlength (ex_file) );
dbms_lob.loadfromfile( dc, dc_file, dbms_lob.getlength (dc_file) );
dbms_lob.fileclose(sc_file);
dbms_lob.fileclose(ex_file);
dbms_lob.fileclose(dc_file);
commit;
END;
esto me da erro en el returning sabeis porque????
Valora esta pregunta


0