Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 31, 2005, 9:37 pm
rate this thread
For example, I have the following:
chomp ($login_name = uc(<STDIN>));
Now, I want to send that $login_name to a SQL script. I'm doing
something like the following:
$sql = "declare \n";
$sql .= " v_new_pswd varchar2(20); \n";
$sql .= "begin \n";
$sql .= " v_new_pswd := db_login.crypt_passwd('NEW_PASSWORD'); \n";
$sql .= " update table set pswd = v_new_pswd where user_id =
$sql .= "end; \n";
$sql .= "/ \n";
$sql .= "commit; \n";
@output = run_sql_query ($login,$password,$sql);
I'm using some libraries that came with my system so I know that
everything is working correctly except that the login_name isn't being
How can I format the login_name so it's correctly interpreted in
my SQL script?
Re: Send Parameter to SQL
> How can I send a parameter I read inside of a PERL script to a SQL
> For example, I have the following:
> chomp ($login_name = uc(<STDIN>));
> Now, I want to send that $login_name to a SQL script. I'm doing
> something like the following:
Do you possibly need to use:
chomp (my $login_name = uc(<STDIN>));
I'm not sure if that will help seeing that the full script is not
provided so I cannot debug it properly.
k g a b e r t (@at@) x m i s s i o n (.dot.) c o m
* After "extensive" research, I noticed
* that firstname.lastname@example.org received 12
* spam e-mail messages after just two
* posts on usenet groups. If you want
* to email me, use the "encrypted"
* email address at the beggining of my
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum