Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Use of statspack in a pl/sql procedure
Hi all!
I'm trying to run spreport within a pl/sql procedure so that instead
of having a text file with my statistics, I insert those values in
tables so that I can have some kind of history. Everything is fine
apart from the call to statspack.stat_changes. Here is what I do:
sql_query := 'CALL STATSPACK.STAT_CHANGES@'||v_linkname||'(:b1,:b2,:b3,:b4,:b5,:b6..all
my bind variables.....:b86)';
EXECUTE IMMEDIATE sql_query USING IN bid, eid, dbid, inst_num, para,
OUT all my bind varibles....;
And this the error I get:
ERROR at line 1:
ORA-06536: IN bind variable bound to an OUT position ORA-06512: at "CHECKSPACE.PERFSTAT_CHECK", line 193 ORA-06512: at line 1
I know that there are several versions of this package and I have checked that I have the correct number of parameters, but it still fails. Did anyone manage to do a similar thing and actually managed to get it to work? Any help GREATLY appreciated!!! Thanks, Matt. Received on Wed Jul 28 2004 - 04:57:57 CDT