Toad World® Forums

Bind Variables in Toad Data Point 3.5


#1

Toad Data Point 3.2 seemed to remember the previous type and value of a bind variable but my setup of 3.5 doesn’t seem to. Is there something that I need to do enable this feature in 3.5?

Thanks!

-Jason


#2

Just to confirm, are you talking about bind variables in the editor?


#3

Yes, in the editor.

From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]

Sent: Tuesday, September 30, 2014 3:17 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Bind Variables in Toad Data Point 3.5

RE: Bind Variables in Toad Data Point 3.5

Reply by Ryan Johnson

Just to confirm, are you talking about bind variables in the editor?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#4

I am not sure why it should change from remembering previous types to not remembering them. I created QAT-4000 to look into the issue.


#5

I need more info on this. I have seen this before but just for specific data types. Can you post of screen shot of the bind window along with the SQL, datatypes of the bind column and connection type.


#6

select
max(stvterm_code)
as TERM_CODE

from stvterm

WHERE STVTERM_START_DATE
<=:CURR

** Oracle Client Connection throughout

Run 1 – Toad 3.2

Prompt:

Result:

Run 2 – Toad 3.2 (same session and connection)

Prompt:

Result:

Run 1 – Toad 3.5

Prompt:

Result:

Run 2 – Toad 3.5 (same session and connection)

Prompt:

The type and value reset

Run 3 – Toad 3.2 (new session and connection)

Close Toad

Open Toad and rerun sql from above

Prompt:

The type and value are still retained.

Thanks!

Jason L. Horn


Database Analyst

Concordia University

t 503-493-6557

2811 NE Holman Street Portland, OR 97211

www.cu-portland.edu

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Monday, October 13, 2014 5:51 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Bind Variables in Toad Data Point 3.5

RE: Bind Variables in Toad Data Point 3.5

Reply by Debbie Peabody

I need more info on this. I have seen this before but just for specific data types. Can you post of screen shot of the bind window along with the SQL, datatypes of the bind column and connection
type.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#7

I can see the same behavior in Toad 3.6, you have change the data type to datetime or small datetime each time you run the query manually with a date bind variable. I have not checked to see if Automation handles this better.


#8

Something is wrong. Is stvterm a synonym or table? I can produce something similar if the object I am selecting from is a synonym. Is it possible that the connection is changing between executions and uses different sessions schemas? It is possible in Oracle to have the same name be a synonym and an object name but have different owners. Can you look into the details stvterm and the connections/editor schema you are using?


#9

Specifying the schema cleared this up. STVTERM had a synonym Thanks! -Jason

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Friday, October 17, 2014 7:13 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Bind Variables in Toad Data Point 3.5

RE: Bind Variables in Toad Data Point 3.5

Reply by Debbie Peabody

Something is wrong. Is stvterm a synonym or table? I can produce something similar if the object I am selecting from is a synonym. Is it possible that the connection is changing between executions
and uses different sessions schemas? It is possible in Oracle to have the same name be a synonym and an object name but have different owners. Can you look into the details stvterm and the connections/editor schema you are using?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.