In Oracle I have following query and error, plz give solution | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
0

In Oracle I have following query and error, plz give solution

>run C:\mydata\demobld.sql Error:- SP2-0103 : Nothing in SQL buffer to run

23rd Feb 2021, 6:03 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
9 Réponses
0
The question does not have enough information. Where did you get demobld.sql, or what are the contents if you made it yourself?
23rd Feb 2021, 6:54 PM
Wilbur Jaywright
Wilbur Jaywright - avatar
+ 1
Ok thank you for trying to help
23rd Feb 2021, 7:06 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
0
demobld.sql is file provided by oracle which contains basic operational tables
23rd Feb 2021, 6:59 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
0
without knowing much about SQL, I’ll ask this. Are you sure it’s meant to run by itself? If it’s simply meant to provide functions for another program to use, it may not be able to run on its own. I’m feeling a little silly since you probably know more about this than me, and I might be putting my foot in
23rd Feb 2021, 7:00 PM
Wilbur Jaywright
Wilbur Jaywright - avatar
0
I don't but last time 2-3 months ago no such error occurred here
23rd Feb 2021, 7:02 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
0
ahh. Have you installed new libraries or changed your file system configuration since then?
23rd Feb 2021, 7:04 PM
Wilbur Jaywright
Wilbur Jaywright - avatar
0
No
23rd Feb 2021, 7:04 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
0
I opened oracle 2after 2-3 gap without doing anything
23rd Feb 2021, 7:05 PM
Abhishek Chaudhari
Abhishek Chaudhari - avatar
0
hmm, well, i think thats all the generic debugging questions i have. ill leave this to others for now.
23rd Feb 2021, 7:05 PM
Wilbur Jaywright
Wilbur Jaywright - avatar