|
-
HII THANKS Raminder UR REPLY
BUT I EXECUITED UR PROCEDURE IT RETURN ERRORS
LIKE*************
CREATE OR REPLACE PROCEDURE loadLOB_proc IS
Dest_loc BLOB;
Src_loc BFILE := BFILENAME('TDTECH', 'picture1.jpg');
Amount INTEGER := 4000;
BEGIN
SELECT COMPANY_MAP INTO Dest_loc FROM TDTECH11
WHERE COMPANY_ID = 'TD1' FOR UPDATE;
DBMS_LOB.OPEN(Src_loc);
DBMS_LOB.OPEN(Dest_loc);
DBMS_LOB.LOADFROMFILE(Dest_loc, Src_loc, Amount);
DBMS_LOB.CLOSE(Dest_loc);
DBMS_LOB.CLOSE(Src_loc);
COMMIT;
END;
** ERRORS
-----------------------------------------------------------------
PLS-00306: wrong number or types of arguments in call to 'OPEN'
PL/SQL: Statement ignored
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|