Hi,
I want to catch a select-result into perl-variable, like this (on Linux):
$C = system ("sqlplus $DBUSER/$DBPW \@getcolnam.sql $TABNAM $TABOWNER ");
Wenn I run this, I see Oracle's output properly, but I can't catch the result in a perl variable. $C is empty, I also tried @C but there is nothing in.
I used exactly this mehtod years ago without any problems.
...
LaoDe
Last Activity: Aug 25 '08, 04:46 AM
Joined: Sep 29 '06
Location:
-
invoking sqlplus from perl show no output
-
Hi,
you may have a path problem, according to the new oracle version. check ind what path oracle is looking for tnsnames.
Also the global dbname may have changed in the init<sid> some days ago. this takes effect while rebooting.
just go step by step and compare above parameter to listener.ini and tnsnames and path and I'm sure you have access to your db again.
LaoDe -
Hi,
this is a mySQL question and should be postede in the mySQL-formun !
How ever, your problem vonsists of 2 parts:
1. identify max(id) ! Have look in mySQL-Docu under aggregate functions or 'group by' ! this orientation might look a bit missleading, since max retrieves only 1 value, but it belongs to the aggregate functions.
2. to fill the gap of numbers, you get by deleting records, you have...Leave a comment:
-
why do you want to put INSECTs into your DB ???Leave a comment:
-
PHP echo does not apear in html
Hi,
Even a very easy php-in-html script does not work in my environment and I can't find any tutorial, which tells about how to bring the pieces together.
Here is my 'giant' code:
<html>
<head>
<title>a giant hmtl page</title>
</head>
<body>
<? print "php output "; ?>
</body>
</html>... -
Apache looks in hidden path
Hi,
How can I trace, where Apache gots a html file from localy on my system ?
I changed index.html in DocumentRoot, but Apache still shows the old version , when I call it by 'localhost' in firefox.
But when I enter 'localhost/index.html' than I get my version of index.html
I checked the path 100 times, I reboot Apache and the browser, no change !???
here are all relevant... -
Hi,
Just to let you know: I am 1 step further:
When I run the form-html as index.html and therfore run it via Apache, the PHP-output is fine.
So I need to learn now to make Apache + html + PHP + mySQL working fine together.
Right now I wonder, why Apache comes up with it's dummy page (which is renamed to index.html.org) , when I call 'localhost' and runs my form-html only, if I call localhost/index.html...Leave a comment:
-
Hi Roverdonk,
Thanks for the tip, even so it isn't the problem.
You are right, during all that testing, I missed that 'e' in the PHP-script, but now, after deleting the that 'e' from the html-script, the problem is still the same, just empty, white screen.
Could it be, that I need to run this 2 pages through an index.html or index.php via Apache, to make it work ?
you see, I'm pretty bloody unexperienced...Leave a comment:
-
$_POST shows nothing, how to debug ?
Hi,
I'm new to PHP and html but think I got to learn that stuff now, after some years Database-experience.
Iworking at my first form and can't see anything in the PHP-output, even no error-message !??? here are the 'giant' scripts:
1. html form:
<html>
<head>
<title>My first PHP-Form</title>
</head>
<body>
<form method="post"...
No activity results to display
Leave a comment: