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
Just to confirm, are you talking about bind variables in the editor?
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.
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.
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.
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
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.
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.
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?
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.