How to call a global variable in to a procedure?

[system]

Hi All

I need to call a value of global variable in to a parameter ofa procedure.

In Detail i will give an example:-

$G_Date = sysdate;

i have to call the value of $G_Date in the procedure.

I have tried by calling

sql(‘phy_audit’,‘begin sh_par(’[$G_Date]’);end;’ );

when executed it throwed a error as ORA-01861: literal does not match format string

Can anyone help me in solve this

Thanks in advance
Shravan

---

shravankumar (BOB member since 2010-08-17)

[system]

Don’t use escape character.

---

kdspvp (BOB member since 2007-10-15)

[system]

Things you should never do - a collection and discussion

Approach: I want to use a date inside the sql() function Solution: sql(‘DataStore’, 'DELETE FROM table WHERE date_col = [$start_date] '); Problem with that: is actually multi-fold. First is the parameter substitution. In all strings DataServices does see, it will check for either [] or {} combinations. Each text inside these brackets will be put into the expression parser and replaced by its value. So the string ‘1+1=[1+1]’ will result in the string ‘1+1=2’. And with {} extra quotes will be p…

The date gets converted to a string in a different format than Oracle expects.

---

Werner Daehn (BOB member since 2004-12-17)