Javed C wrote:For ODI related query it is better to post it in ODI forum
I am using ODI 10g.
I have created a package which contains some procedures.In one of the procedure there is an insert statement.Regenerated procedure means ? Did you re-write the procedure code or Regenerated scenario of it ?
The values earlier inserted using this procedure was cosntant so there was no problem, but now I want to insert a value which i m getting from a variable declared as global in the package.
I created a new global variable , provided the query and all.After that I regenerated the procedure.
Now as per my understandingNo .. Global variable does not show unter any package/project tree . It is visible in Other tab -->Global variables
1.That variable should come in the variable list of package.
2.The procedure should use this variable and insert the values as per the variable.How/what have you written in the procedure code to get the global variable's value ?
But neither i am getting the variable in package as well the procedure is not inserting the variable value.
Please let me know if there are any steps i m forgotten or some other way to implent this.
Thanks is advance.