• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • paul wheaton
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • Mikalai Zaikin
  • Himai Minh

running sql scripts

 
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

At the time of running sql scripts it is asking my sourcepath,TNS entry, and password in command prompt I am providing these values(whenever I run script I need to give this values)I am getting these values in my sql script,now I want to provide these values from properties file to run my scripts.Can I get these values from properties files.
 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What do you use for executing sql scripts? Is it sqlplus? if so
 
Reshma Reddy
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi keles,

thanks for your reply,

I don't know exactly how to run these scripts. my database admin is running these scripts at the time of running scripts it is asking path.tns name and password, I want get these fields from properties file I need to get these values in script file it self. now I am taking from command prompt.

regards,
vardhan

 
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
To run an SQL script, select one of the following options from the Run menu:
All - Runs your SQL script from the beginning to the end. If an error occurs and the Stop on Error option is turned on, the program stops and the statement where the error occurred remains selected.
From Selected - Starts your SQL script from the first statement that is selected or from the current cursor position and continues to the end of the script.
Selected - Runs the statements that are selected.
The results are added to the end of the Messages tab. If the Smart Statement Selection option on the Options menu is not checked, the text that is selected is run as a single SQL statement.
 
Reshma Reddy
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't have my scripts in my Database, i need to run the scripts i got(at the time of building application my build file will generate some scripts).

I need to take this scripts and need to run this (Imp: scripts not in database, there in my C drive)


thanks,
 
I yam what I yam and that's all that I yam - the great philosopher Popeye. Tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic