Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Use of statspack in a pl/sql procedure

Use of statspack in a pl/sql procedure

From: Matt <matthieu.atkinson_at_eu.altria.com>
Date: 28 Jul 2004 02:57:57 -0700
Message-ID: <f683f010.0407280157.61f40dfe@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US