i have file in the unix path
Path /popdev01/pop/popdevb/tfi/
File name: qua01
this path is hard coded in the table PQ10. i will be taking this value and get assinged to the variable "Var_val"
DECLARE
Fic_Lu UTL_FILE.file_type ;
Var_val VARCHAR2(50);
vs_mod_r := 'r' ;
SELECT val
* INTO Var_val*
* FROM pq10*
* WHERE pq10_COD_PRM='RF';*
Fic_Lu := UTL_FILE.FOPEN ( Var_val,'qua01', vs_mod_r, 3000 ) ;
exception
WHEN UTL_FILE.INVALID_PATH THEN
dbms_output.put_line(' Invalid path');
end;
while i run i get invalid path error
Give me ur suggestion
Time script, set to my time zone?
I am using this line to get the date and timeCode: $time = date(F." ".d.", ".Y." ".g.":".i.":".sa,time());How could I change this to my time zone here
how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a sessionCode: <?phpinclude_once 'Connect.php';if (!is_authed()) { die ('You are not
Save file by click
Hello. I'm not understand how to save file from page. I'd like make link to file with save ability.<?phpchdir('upload/');foreach (glob("*.*") as $filename) { $uploadfile =
Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place that it is hosted just did some upgrades to their servers and for some reason, now my login page
Setting a default timezone?
I have read about how to change the timezone in PHPMYADMIN, but it changes back, it doesn't STAY there.If thats not possible, if I had..;$time = date("d-m-Y H-i-s" time());or.. if I had
how to transport the Query and insfoset
Hi
xApp Analytics in BI 7.0
Dear all,
How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array.. 1st array:Code: Array( [0] => zero [1] => one [2] => two)2nd array:Code:
help with calculations on a flat text file
hello,I have this code below that is attached to a flat file like this:Email:LastName:FirstName:Assignment1,100:Assignment2,100:Quiz1,50someone@email.com:Doe:John:85:93:45Here is the code:
Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!I've got a MySQL database setup with a table that has multiple fields, where one is a numerical
