Passing BLOB/CLOB as parameter to PL/SQL function
Posted
by Ula Krukar
on Stack Overflow
See other posts from Stack Overflow
or by Ula Krukar
Published on 2009-09-02T13:52:26Z
Indexed on
2010/04/30
15:07 UTC
Read the original article
Hit count: 287
I have this procedure i my package:
PROCEDURE pr_export_blob(
p_name IN VARCHAR2,
p_blob IN BLOB,
p_part_size IN NUMBER);
I would like for parameter p_blob to be either BLOB or CLOB.
When I call this procedure with BLOB parameter, everything is fine. When I call it with CLOB parameter, I get compilation error:
PLS-00306: wrong number or types of arguments in call to 'pr_export_blob'
Is there a way to write a procedure, that can take either of those types as parameter? Some kind of a superclass maybe?
© Stack Overflow or respective owner
