the scenario is such
what i have done is that i have defined a package variable in the package.
Now The package has 4 sps and i function.
I assign a value to the package variable in one of the sps.
using this value, I insert it into a temporary which i create inside the sp.(using execute immediate)
can i do this.i get an error of previliges which was sorted out.
Now i am accesiing the data in the temp table inside the function.the function returns me an id which is retrieved from another table using the value in the temp table.
This function is called inside a trigger,which is fired when any data is updated or deleted in a particular table On This i get an error ora-04601-existing state of package being discarded.