Tagged Questions
2
votes
1answer
227 views
Can't return data from SQL/Plus and Toad but can from SQL Developer
This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select ...
3
votes
1answer
368 views
halt on error in a sqlplus script
I am deploying pl/sql code using several sql files that are called with @@file.
If a package got a compilation error the script continues to the end.
Is there a way to stop on every compilation ...
2
votes
1answer
947 views
Oracle not available error with Oracle XE 11.2.0-1.0
I have downloaded Oracle XE 11.2.0-1.0 and installed it on a CentOS 6.3 virtual machine with 1.5GB memory and 3GB of swap.
SYS and SYSTEM set to have password 123456. I have set ...
1
vote
1answer
2k views
Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper
I have following example query.
variable pStartDateBegin VARCHAR2(10);
variable pEndDateFinish VARCHAR2(10);
begin
select '01-01-2000', '30-11-2011'
into ...
