don' t see bind variables

[Former Member]

hi,

in shared cursor cache, all sql statement's explain that variables are only 'V$SQL_BIND_CAPTURE'.

why to see bind variables!

thanks in advance

ferhan

[stefan_koehler]

Hello Ferhan,

what is your question? How do you look for the bind variables?

Normally you see the bind values in a ST05 trace or with a manually written SELECT statement on the corresponding views.

Regards

Stefan

[Former Member]

hi stefan,

don't see bind variables in st04.

together, don't see that in st05. how to see th bind variables in st05.

thanks

ferhan

[KayKa]

Hi Ferhan,

in the st05 it's shift + F2, in the st04 explain screen you need shift + F7.

hth

Kay

[stefan_koehler]

Hello Ferhan,

>don't see bind variables in st04.

That is a normal behavior. SAP just shows the SQL statement and the corresponding execution plan in ST04. You can also jump to the part of ABAP code which is executing that SQL statement .. but that's it.

> how to see th bind variables in st05.

Activate the SQL trace ... run your ABAP program ... Deactivate SQL trace .. Show SQL trace .. double click on the OPENED SQL statement .. and there it is..

Regards

Stefan

[Former Member]

hi kay,

shift+f7-> only see V$SQL_BIND_CAPTURE

thanks

[Former Member]

hi stefan,

don't see bind variables. only last time captured is V$SQL_BIND_CAPTURE.

but

in toad, i can see that select * from V$SQL_BIND_CAPTURE where sql=$sql name .

why don't see in SAP

thanks

ferhan

[fidel_vales]

Hi,

What is your database version? and your SAP BASIS patch level?

If you have done a trace, you see the content of the variables in the trace (already mentioned), in the ST05 explain plan you do not see anything because it is an explain plan.

If you find the sql statement in the shared pool and explain it, it will show you the access path from the V$plan, not from explain plan and you can have a button to see V$SQL_BIND_CAPTURE. This depends on your basis and patch level (do not ask me when it appeared, I do not know, you can search for notes)

in addition, you can also execute the query you mention in SAP (ST04N, dbacockpit, SE38)

But, I am not clear on what is the question. could you explain properly what is your problem?

I do not understand the following

> in shared cursor cache, all sql statement's explain that variables are only 'V$SQL_BIND_CAPTURE'.

> why to see bind variables!

do you want to see the bind? you do not find the button? what? ...

> shift+f7-> only see V$SQL_BIND_CAPTURE

ok, you see the V$SQL_BIND_CAPTURE, but you complain because ....?

[Former Member]

hi,

the database version is 10.2. basis patch level is 0018.

thanks.

ferhan

[fidel_vales]

>

> hi,
> the database version is 10.2. basis patch level is 0018.
> thanks.
> 
> ferhan

good, patch 18 of basis version ????

but what about answering the question about what do you really want?

[Former Member]

hi,

SAPKB70018 Basis Support Package 18 for 7.00 imported at 15.06.2009, 03:34:02

thanks in advance

ferhan

[Former Member]

hi stefan,

on st04 -> select a row and explain > bind variables ;

i only see V$SQL_BIND_CAPTURE ; not see 'A0' s value.

SELECT

*

FROM

"MARA"

WHERE

"MANDT" = :A0 AND "MATNR" = :A1#

thanks for advance

ferhan