Hi!

I arrived in this new work place and i'm trying to figure out how they work. I found a lot of procedures and packages that repeatedly call each other and i'm wondering if and how this kind of things effected oracle performances.

In particular, i came across this string in a function:

v_SqlText := 
  'SELECT SIANAGR.ANACODANA  '||LsGlobal.c_LF||
  '  FROM SIANAGR            '||LsGlobal.c_LF||
  ' WHERE SIANAGR.ANAPIVA =  '||LsGlobal.c_APICE||v_CFisc||LsGlobal.c_APICE||LsGlobal.c_LF;

LsGlobal is another package, c_LF is a constant in the specification := chr(10), c_APICE another constant := '''' and v_CFisc is an IN parameter.

Is it true that Oracle every time encounters a package.variable, makes a call? If it's true, this string is a bad coding example?
Is there a way to trace how an in what time oracle resolves this string?

Many thanks for the help,
Gaia

SELECT SIANAGR.ANACODANA
INTO ...
FROM SIANAGR            
WHERE SIANAGR.ANAPIVA =  v_CFisc ;