f



php code from plsql using owa htp.p

can I run phpinfo(); or any php code from an oracle plsql package using
htp.p from the oracle web toolkit owa?

thanks

0
marvado (12)
2/28/2006 4:33:19 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

8 Replies
15624 Views

Similar Articles

[PageSpeed] 50

I have no idea what phpinfo() does, but htp.p pushes whatever is as
parameter to
htp.p out to the web, using the mod_plsql.
So, if you have Apache by Oracle, and a call to a procedure that will
htp.p('phpinfo()');
your browser will receive phpinfo() - I doubt that is what you want.


Regards, 
Frank van Bortel

0
2/28/2006 7:08:19 PM
Hi Frank,

what I need is to run any php code using htp.p()
I might be missing something, in my oracle/apache/php configuration I
can only run flat .php files from /htdocs but can't run any php from a
plsql procedure to display on a browser with htp.p

anyone has ideas?

*btw phpinfo() is an internal php function that shows among other
things, all php environmental variables for your system.

--pedro.

0
marvado (12)
2/28/2006 9:52:28 PM
marvado@hotmail.com wrote:

> can I run phpinfo(); or any php code from an oracle plsql package using
> htp.p from the oracle web toolkit owa?

Not directly. Your two main options: invoke php scripts indirectly via html;
i.e. htp.p('<a href="http://server.tld/script.php">some php link</a>'), or;
use package UTL_HTTP.
0
Gerry
2/28/2006 11:24:13 PM
hm,

don't know if that's what I'd like to do. I basically am seeking a way
to invoke php from a package and keep everything within the database
without the need for flat files.

thanks

0
marvado (12)
3/1/2006 5:56:29 AM
On Tue, 28 Feb 2006 08:33:19 -0800, marvado wrote:

> can I run phpinfo(); or any php code from an oracle plsql package using
> htp.p from the oracle web toolkit owa?

You can, if you have a way of starting PHP interpreter from PL/SQL.
Proposed way of doing that would be the following: 

1) Find a way to link PHP module into Oracle RDBMS as an external
   procedure. That is not as far-fetched as it seems: there is
   such a software for perl. It's called "extproc_perl" and 
   can be found at: http://www.smashing.org/extproc_perl/
2) Use it from Oracle PL/SQL. If you want to call your package
   "HTP", you're more then welcome. Oracle doesn't reserve that
   name.

-- 
http://www.mgogala.com

0
gogala (1324)
3/1/2006 6:45:03 AM
On Tue, 28 Feb 2006 13:52:28 -0800, marvado wrote:

> *btw phpinfo() is an internal php function that shows among other
> things, all php environmental variables for your system.
> 
> --pedro.


It produces output like this:


PHP Version 5.1.2

System 	Linux medo.noip.com 2.6.15.4 #1 Tue Feb 21 20:34:25 EST 2006 i686
Build Date 	Feb 26 2006 03:55:09
Configure Command 	'./configure' '--with-apxs2=/opt/apache/bin/apxs' '--with-xmlrpc' '--with-zlib' '--with-bz2' '--with-ttf' '--with-gd' '--enable-gd-native-ttf' '--with-t1lib' '--with-freetype-dir' '--with-jpeg-dir' '--with-png-dir' '--with-config-file-path=/usr/local/lib/php' '--enable-sigchild' '--without-sqlite' '--without-pdo-sqlite' '--disable-mysql' '--with-oci8=/oracle/product/10g' '--with-pdo-oci=/oracle/product/10g'
Server API 	Apache 2.0 Handler
Virtual Directory Support 	disabled
Configuration File (php.ini) Path 	/usr/local/lib/php/php.ini
PHP API 	20041225
PHP Extension 	20050922
Zend Extension 	220051025
Debug Build 	no
Thread Safety 	disabled
Zend Memory Manager 	enabled
IPv6 Support 	enabled
Registered PHP Streams 	php, file, http, ftp, compress.bzip2, compress.zlib
Registered Stream Socket Transports 	tcp, udp, unix, udg
Registered Stream Filters 	string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, convert.iconv.*, bzip2.*, zlib.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

PHP Credits
Configuration
PHP Core
Directive	Local Value	Master Value
allow_call_time_pass_reference	Off	Off
allow_url_fopen	On	On
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	no value	no value
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	2047	2047
expose_php	On	On
extension_dir	/usr/local/lib/php/extensions/no-debug-non-zts-20050922	/usr/local/lib/php/extensions/no-debug-non-zts-20050922
file_uploads	On	On
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/usr/local/lib/php:/usr/local/PHP	.:/usr/local/lib/php:/usr/local/PHP
log_errors	On	On
log_errors_max_len	1024	1024
magic_quotes_gpc	Off	Off
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
mail.force_extra_parameters	no value	no value
max_execution_time	30	30
max_input_time	60	60
open_basedir	no value	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	16K	16K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
register_globals	Off	Off
register_long_arrays	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
safe_mode	Off	Off
safe_mode_exec_dir	no value	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i 	/usr/sbin/sendmail -t -i 
serialize_precision	100	100
short_open_tag	On	On
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	2M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	On	On
zend.ze1_compatibility_mode	Off	Off

apache2handler
Apache Version 	Apache/2.0.54 (Unix) PHP/5.1.2
Apache API Version 	20020903
Server Administrator 	gogala@sbcglobal.net
Hostname:Port 	localhost:80
User/Group 	nobody(99)/-1
Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 15
Virtual Server 	No
Server Root 	/opt/apache
Loaded Modules 	core mod_access mod_auth mod_include mod_log_config mod_env mod_setenvif prefork http_core mod_mime mod_status mod_autoindex mod_asis mod_cgi mod_negotiation mod_dir mod_imap mod_actions mod_userdir mod_alias mod_so mod_php5

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment
Variable	Value
HTTP_HOST 	localhost
HTTP_USER_AGENT 	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.1) Gecko/20060124 Firefox/1.5.0.1
HTTP_ACCEPT 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.5
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 	300
HTTP_CONNECTION 	keep-alive
HTTP_COOKIE 	OracletoolRecent=10G; 10G.sessionid=b3BzJG1nb2dhbGE%3D-cXdlcnR5-Z6mkr%2Blk7Mq%2F2lcHnmI5YQ%3D%3D
PATH 	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE 	<address>Apache/2.0.54 (Unix) PHP/5.1.2 Server at localhost Port 80</address>
SERVER_SOFTWARE 	Apache/2.0.54 (Unix) PHP/5.1.2
SERVER_NAME 	localhost
SERVER_ADDR 	127.0.0.1
SERVER_PORT 	80
REMOTE_ADDR 	127.0.0.1
DOCUMENT_ROOT 	/opt/apache/htdocs
SERVER_ADMIN 	gogala@sbcglobal.net
SCRIPT_FILENAME 	/usr/local/mydoc/first.php
REMOTE_PORT 	50674
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/mydoc/first.php
SCRIPT_NAME 	/mydoc/first.php

HTTP Headers Information
HTTP Request Headers
HTTP Request 	GET /mydoc/first.php HTTP/1.1
Host 	localhost
User-Agent 	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.1) Gecko/20060124 Firefox/1.5.0.1
Accept 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language 	en-us,en;q=0.5
Accept-Encoding 	gzip,deflate
Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 	300
Connection 	keep-alive
Cookie 	OracletoolRecent=10G; 10G.sessionid=b3BzJG1nb2dhbGE%3D-cXdlcnR5-Z6mkr%2Blk7Mq%2F2lcHnmI5YQ%3D%3D
HTTP Response Headers
X-Powered-By 	PHP/5.1.2
Keep-Alive 	timeout=15, max=100
Connection 	Keep-Alive
Transfer-Encoding 	chunked
Content-Type 	text/html; charset=ISO-8859-1

bz2
BZip2 Support 	Enabled
Stream Wrapper support 	compress.bz2://
Stream Filter support 	bzip2.decompress, bzip2.compress
BZip2 Version 	1.0.2, 30-Dec-2001

ctype
ctype functions 	enabled

date
date/time support 	enabled
Timezone Database Version 	2005.18
Timezone Database 	internal
Default timezone 	America/New_York

Directive	Local Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	no value	no value

dom
DOM/XML 	enabled
DOM/XML API Version 	20031129
libxml Version 	2.6.22
HTML Support 	enabled
XPath Support 	enabled
XPointer Support 	enabled
Schema Support 	enabled
RelaxNG Support 	enabled

gd
GD Support 	enabled
GD Version 	bundled (2.0.28 compatible)
FreeType Support 	enabled
FreeType Linkage 	with freetype
FreeType Version 	2.1.9
T1Lib Support 	enabled
GIF Read Support 	enabled
GIF Create Support 	enabled
JPG Support 	enabled
PNG Support 	enabled
WBMP Support 	enabled
XBM Support 	enabled

hash
hash support	enabled
Hashing Engines	md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv
iconv support 	enabled
iconv implementation 	glibc
iconv library version 	2.3.6

Directive	Local Value	Master Value
iconv.input_encoding	ISO-8859-1	ISO-8859-1
iconv.internal_encoding	ISO-8859-1	ISO-8859-1
iconv.output_encoding	ISO-8859-1	ISO-8859-1

libxml
libXML support 	active
libXML Version 	2.6.22
libXML streams 	enabled

oci8
OCI8 Support 	enabled
Revision 	$Revision: 1.269.2.8 $
Active Persistent Connections 	0
Active Connections 	0
Oracle Version 	10.1
Compile-time ORACLE_HOME 	/oracle/product/10g
Libraries Used 	no value
Temporary Lob support 	enabled
Collections support 	enabled

Directive	Local Value	Master Value
oci8.default_prefetch	10	10
oci8.max_persistent	-1	-1
oci8.old_oci_close_semantics	0	0
oci8.persistent_timeout	-1	-1
oci8.ping_interval	60	60
oci8.privileged_connect	Off	Off
oci8.statement_cache_size	20	20

pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	6.2 01-Aug-2005

PDO
PDO support	enabled
PDO drivers 	oci

PDO_OCI
PDO Driver for OCI 8 and later	enabled

posix
Revision 	$Revision: 1.70.2.3 $

Reflection
Reflection	enabled
Version 	$Id: php_reflection.c,v 1.164.2.17 2006/01/01 12:50:12 sniper Exp $

session
Session Support 	enabled
Registered save handlers 	files user
Registered serializer handlers 	php php_binary

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.bug_compat_42	Off	Off
session.bug_compat_warn	On	On
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_secure	Off	Off
session.entropy_file	no value	no value
session.entropy_length	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.hash_bits_per_character	5	5
session.hash_function	0	0
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	no value	no value
session.serialize_handler	php	php
session.use_cookies	On	On
session.use_only_cookies	Off	Off
session.use_trans_sid	0	0

SimpleXML
Simplexml support	enabled
Revision 	$Revision: 1.151.2.10 $
Schema support 	enabled

SPL
SPL support	enabled
Interfaces 	Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes 	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

standard
Regex Library 	Bundled library enabled
Dynamic Library Support 	enabled
Path to sendmail 	/usr/sbin/sendmail -t -i

Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
safe_mode_allowed_env_vars	PHP_	PHP_
safe_mode_protected_env_vars	LD_LIBRARY_PATH	LD_LIBRARY_PATH
url_rewriter.tags	a=href,area=href,frame=src,input=src,form=fakeentry	a=href,area=href,frame=src,input=src,form=fakeentry
user_agent	no value	no value

tokenizer
Tokenizer Support 	enabled

xml
XML Support 	active
XML Namespace Support 	active
libxml2 Version 	2.6.22

xmlreader
XMLReader 	enabled

xmlrpc
core library version 	xmlrpc-epi v. 0.51
php extension version 	0.51
author 	Dan Libby
homepage 	http://xmlrpc-epi.sourceforge.net
open sourced by 	Epinions.com

xmlwriter
XMLWriter 	enabled

zlib
ZLib Support 	enabled
Stream Wrapper support 	compress.zlib://
Stream Filter support 	zlib.inflate, zlib.deflate
Compiled Version 	1.2.2.2
Linked Version 	1.2.2.2

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules
Module Name

Environment
Variable	Value
CONSOLE 	/dev/console
SELINUX_INIT 	YES
TERM 	linux
NLS_LANG 	AMERICAN_AMERICA.WE8ISO8859P1
TWO_TASK 	local
LD_LIBRARY_PATH 	/opt/apache/lib:/oracle/product/10g/lib
INIT_VERSION 	sysvinit-2.85
ORA_NLS10 	/oracle/product/10g/nls/data
PATH 	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
TNS_ADMIN 	/oracle/product/10g/network/admin
runlevel 	5
RUNLEVEL 	5
PWD 	/
LANG 	en_US
previous 	N
PREVLEVEL 	N
SHLVL 	3
HOME 	/
APACHE_HOME 	/opt/apache
ORACLE_HOME 	/oracle/product/10g
_ 	/opt/apache/bin/httpd

PHP Variables
Variable	Value
_REQUEST["OracletoolRecent"]	10G
_REQUEST["10G_sessionid"]	b3BzJG1nb2dhbGE=-cXdlcnR5-Z6mkr+lk7Mq/2lcHnmI5YQ==
_COOKIE["OracletoolRecent"]	10G
_COOKIE["10G_sessionid"]	b3BzJG1nb2dhbGE=-cXdlcnR5-Z6mkr+lk7Mq/2lcHnmI5YQ==
_SERVER["HTTP_HOST"]	localhost
_SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.1) Gecko/20060124 Firefox/1.5.0.1
_SERVER["HTTP_ACCEPT"]	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_LANGUAGE"]	en-us,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"]	300
_SERVER["HTTP_CONNECTION"]	keep-alive
_SERVER["HTTP_COOKIE"]	OracletoolRecent=10G; 10G.sessionid=b3BzJG1nb2dhbGE%3D-cXdlcnR5-Z6mkr%2Blk7Mq%2F2lcHnmI5YQ%3D%3D
_SERVER["PATH"]	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"]	<address>Apache/2.0.54 (Unix) PHP/5.1.2 Server at localhost Port 80</address>
_SERVER["SERVER_SOFTWARE"]	Apache/2.0.54 (Unix) PHP/5.1.2
_SERVER["SERVER_NAME"]	localhost
_SERVER["SERVER_ADDR"]	127.0.0.1
_SERVER["SERVER_PORT"]	80
_SERVER["REMOTE_ADDR"]	127.0.0.1
_SERVER["DOCUMENT_ROOT"]	/opt/apache/htdocs
_SERVER["SERVER_ADMIN"]	gogala@sbcglobal.net
_SERVER["SCRIPT_FILENAME"]	/usr/local/mydoc/first.php
_SERVER["REMOTE_PORT"]	50674
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["REQUEST_METHOD"]	GET
_SERVER["QUERY_STRING"]	no value
_SERVER["REQUEST_URI"]	/mydoc/first.php
_SERVER["SCRIPT_NAME"]	/mydoc/first.php
_SERVER["PHP_SELF"]	/mydoc/first.php
_SERVER["REQUEST_TIME"]	1141195856

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.



-- 
http://www.mgogala.com

0
gogala (1324)
3/1/2006 6:53:39 AM
can't find an interperter like you said, Mladen

thanks

0
marvado (12)
3/1/2006 4:20:26 PM
marvado@hotmail.com wrote:

> hm,
> 
> don't know if that's what I'd like to do. I basically am seeking a way
> to invoke php from a package and keep everything within the database
> without the need for flat files.

There is no php in Oracle... period!  But there is another option, you could
create an external library (say, using GNU gcc) to invoke php, then
register the library and wrapper in Oracle and invoke it from pl/sql.  You
could use pipes to avoid doing file i/o.  The drawback is you app will
become platform-dependent.

Here's a link that should help you get started:  

http://home.clara.net/dwotton/dba/oracle_extn_rtn.htm
0
Gerry
3/1/2006 6:38:29 PM
Reply:

Similar Artilces:

Connect to two different Oracle servers using PHP / Perl ?
Hi, I'm running Apache 2.2.3, and PHP 5.1.4 on Apache 2.2.3, on a Sparc Solaris 5.10 box. Our Oracle DBA installed the Oracle 10g server and client on the web server. He also installed the Oracle 9i Client (only), so that I can also connect to a remote 8i server. I have to set my $ORACLE_HOME each time I switch between the two clients. Is there a better way to do this? How can I configure PHP to connect to both? Is it possible? I tried to set up Oracle's Instant Client, but I couldn't get it to connect to either database. The closest I got to connecting to the remote server was an error that said "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor". Thanks, Jamie livefreeordie wrote: > Hi, > > I'm running Apache 2.2.3, and PHP 5.1.4 on Apache 2.2.3, on a Sparc > Solaris 5.10 box. Our Oracle DBA installed the Oracle 10g server and > client on the web server. He also installed the Oracle 9i Client > (only), so that I can also connect to a remote 8i server. > > I have to set my $ORACLE_HOME each time I switch between the two > clients. > > Is there a better way to do this? > > How can I configure PHP to connect to both? Is it possible? > > I tried to set up Oracle's Instant Client, but I couldn't get it to > connect to either database. The closest I got to connecting to the > remote server was an error that said "ORA-12514: TNS:listen...

Can I use PHP for selecting and writing data into a server-database?
Hi, I like to build a small simple dinamic website: Point-of-sale (detail-shop), So entering stock, logging all sales, print out invoices and download the logs to be imported into Excel. I once could write a bit in ASP/SQL/HTML/JAVASCRIPT and even some Excel-VBA but have lost most knowledge about that and I never know a lot nor did I know how to set up a simulating PC to write and test the website. I don't want to spend much money buying Microsoft product, so I've heard that PHP with MySQL can do it for free, right? But all I find is that PHP can look up data in a file on the server...

Using the DBI to connect to an Oracle server w/o connecting to a database
I've searched for the answer to this problem and have not seen it (which suggests what the answer might be ;-) ). Is it possible to use DBI (and DBD::Oracle) to connect to an Oracle server without connecting to a database? This would be the DBI equivalent of: sqlplus /nolog SQL> connect user/passwd@database; or, more similarly: sqlplus /nolog @my.sql where my.sql might be: connect user/passwd@database; select ... etc. I'm thinking this is not possible, but I hope it is. Thanks. Quoth Tim <google@hoodfamily.org>: > I've searched for the answer to this problem and...

Best way to check oracle database server / services is alive using Java
Hi, I am looking for the best way to check whether several oracle (or any database) databases is running or not. At the moment I just attempt to connect to the server IP using Socket and conclude the database is not running if connection timed out. Which is a silly way of doing it. Appreciate any help. Best regards. On Apr 3, 9:56 pm, harishas...@gmail.com wrote: > Hi, > > I am looking for the best way to check whether several oracle (or any > database) databases is running or not. > At the moment I just attempt to connect to the server IP using Socket > and conclude...

moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will be changed. Oracle version is > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). > Does any one know what I need to do in order to get oracle up and > running again on the new server. I know that I will need to change the > tnsnames.ora and listner.ora, but is there anything else that I need > to do? > > Thanks > Teresa When I do this with windows boxes I either: #1 Install oracle on the new box, create a new database and export/import from old db to new db #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or shutdown old_database, startup nomount and recreate the controlfile to fit new environment. #3 Restore from online backup of old_database and apply redo logs, again recreating the controlfile to fit the new env. (I usually only do this for "practice" and for creating a development copy of a prod db) #2 ...

Oracle Database 10g R2 RAC Installation On Red Hat Linux Using VMware Server
Hi, Does any one have the install doc for Oracle Database 10g R2 RAC Installation On Red Hat Linux Using VMware Server. I googled, I searched on OTN and also searched on Metalink but no luck. Thank you RA On May 29, 5:54 pm, RA <ang...@gmail.com> wrote: > Hi, > > Does any one have the install doc for Oracle Database 10g R2 RAC > Installation On Red Hat Linux Using VMware Server. I googled, I > searched on OTN and also searched on Metalink but no luck. > > Thank you > RA Wow you must have missed all the good spots. Try Jeffery Hunters site over at http://www.idevelopment.info or Howard Rogers site at http://www.dizwell.com/prod Be prepared to take their recommendations and follow their documentation exactly. Jeffrey has a nice article on a complete 2 node install of RAC using vmware ... think he uses a clone of red hat in the article. On 30 mayo, 00:24, hpuxrac <johnbhur...@sbcglobal.net> wrote: > On May 29, 5:54 pm, RA <ang...@gmail.com> wrote: > > > Hi, > > > Does any one have the install doc for Oracle Database 10g R2 RAC > > Installation On Red Hat Linux Using VMware Server. I googled, I > > searched on OTN and also searched on Metalink but no luck. > > > Thank you > > RA > > Wow you must have missed all the good spots. > > Try Jeffery Hunters site over athttp://www.idevelopment.infoor > Howard Rogers site athttp://www.dizwell.com/prod > > Be prepare...

oracle 9i database on a aix 4.3.3 server trying to use a 32 bit compiler- error ksms.imp
We are trying to get a new setup to work. We have an Oracle 9.2.0.4 database on AIX 4.3.3. This database is using the 64 bit kernel extension. We have installed Server Express 2.1 for 4.3.3 (MF cobol compiler) which is a 32 bit app. We tried to edit the makefile used for AIX 4.3.3, MF cobol compiler OCDS, Oracle database 8.1.6. We learned about needing to relink rstora32, and the procob32� that has been done. We changed out markefile to point to all the 9i oracle 32 bit directories. We are note experienced with makefiles and not sure our makefile is ok. We are now having problems with the 32 bit version of ksms.imp. At first the file was empty. To resolve that problem we: Generated the ksms.imp as follows.. @ORACLE_HOME/bin/genksms > $ORACLE_HOME/lib32/ksms.imp and relinked the "genksms" binary: make �f $ORACLE_HOME/rdbms/lib32/ins_rdbms.mk $ORACLE_HOME/bin/genksms Do you know if we built this correctly? We do not seem to be able to compile without using the variable ...please note the error with the variable for ksms.imp and without that variable�. I hve included the makefile below Thanks 1. Problem when makefile has commented out line #LIMPEXP=$(LIBHOME)/ksms.imp This error is received for every line of code ld: 0711-418 ERROR: Import or export file /u00/app/oracle/product/9.2.0/lib32/ks ms.imp at line 4219: A symbol name may only be followed by an export attribute or an address. The line is being ignore...

How do I check which Oracle Patches are appplied to an Oracle DataBase Server
I would like to know if someone could help me with this topic, I'm traying to analize and chek which Oracle Patches are appplied to an Oracle DataBase Server >chek which Oracle Patches are appplied to an Oracle DataBase Server If they were applied with oPatch, then "opatch lsinventory" should show you what's there. If you did not use oPatch, then I have no clue. ;-) BD wrote: > >chek which Oracle Patches are appplied to an Oracle DataBase Server > > If they were applied with oPatch, then "opatch lsinventory" should show > you what's there. > > If you did not use oPatch, then I have no clue. ;-) For better or worse ( we know the answer ) opatch is the tool that install patches from oracle support. "If you did not use oPatch" ... what? >"If you did not use oPatch" ... what? In my 8i environments, there are separate scripts that are run - for example, for a cpu, it would be 'install_cpu.sh'. In those cases, I really don't know how (if) one can confirm which patches have been applied to an environment. ...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

Oracle newbie
Appologies if this is a stupid question? Can Internet Directory be used to access an existing Database - i.e access would primarily be via EJB's / JDDBC with LDAP be used as a secondary means of access Not certain what you mean there. Do you mean that login information retained in the Internet Directory store would be retrieved by some application which would then connect to the target database with it? Definitely can be done. That's what it's for, among other things. Oracle has created products that do just this very thing. Some Oracle options depend on it. The Internet Directory does not itself connect to the target database, only to its back end database so far as I know. It simply answers requests from LDAP clients. HTH td brian white wrote: > Appologies if this is a stupid question? > > > Can Internet Directory be used to access an existing Database - i.e > access would primarily be via EJB's / JDDBC with LDAP be used as a > secondary means of access ...

Using Oracle Developer with Oracle 8.1.7 database
Hi. I would like to use the current versions of Oracle Developer Suite I can download from Oracle website (i.e. 10g and 9i), but I will have to connect to an Oracle 8.1.7 dbase. Is it possible to connect to such an "old" database with the current versions or Oracle Developer Suite? Thank you, El DoDo march...@units.it wrote: > Hi. > > I would like to use the current versions of Oracle Developer Suite I > can download from Oracle website (i.e. 10g and 9i), but I will have to > connect to an Oracle 8.1.7 dbase. > Is it possible to connect to such an "old" database with the current > versions or Oracle Developer Suite? > > Thank you, > El DoDo 9i client is backward compatable to 8i. However, 10g is only backwards compatable to certain 8i patchset. I can connect from 10g client to 8.1.7.4.1 but not to 8.1.7.0. Not sure about the in between patchsets as I don't have them. Regards /Rauf marchesa@units.it wrote: > Hi. > > I would like to use the current versions of Oracle Developer Suite I > can download from Oracle website (i.e. 10g and 9i), but I will have to > connect to an Oracle 8.1.7 dbase. > Is it possible to connect to such an "old" database with the current > versions or Oracle Developer Suite? > > Thank you, > El DoDo Yes. Make sure you have patched the 8i database to make it as current as possible. -- Daniel A. Morgan...

How to find SQL Servers & Databases in Each server using BATCH File?
Hi, I need help from you... I want to find SQL Servers which are available in Network and Databases in Each Server Using Batch file. If i run this Batch file it should find SQL Servers & Databases in each server and out put should send to txt file... Is it possible to do this using Batch file??? if possible hw can i??? Plz send me details hw to do... Thanx in Advance, Regards, Raghu Tumma... Mail to: raghutumma@gmail.com ...

Oracle databases on a server
I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the 'HOST' entry points to this server? On Feb 20, 9:00=A0am, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want to find out how many databases are installed on this server. > > Would it be true to say that all databases installed on this server > are listed in tnsnames.ora where the 'HOST' entry points to this > server? No, these might be different *services* served by the same instance. The first place to look at is /var/opt/oracle/oratab file, which should list all Oracle instances on your host. If your Oracle installation follows OFA (Optimal Flexible Architecture,) which is usually true, count $ORACLE_BASE/admin/<dbname> directories - each database should have its own directory under admin. Alternatively, you can also count spfile<SID>.ora files in $ORACLE_HOME/dbs directory. Hth, Vladimir M. Zakharychev N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com On 20 Feb, 06:00, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want...

SqlSpec
Do you wish you had comprehensive, easily navigable documentation for your SQL Server, Oracle, Analysis Server, MySQL, and Access databases? Are you a SQL Developer or DBA that just inherited a huge, complex database with no supporting docs and don't know where to start learning how it's put together? Are you an independent contractor working with SQL Server, Oracle, Analysis Server, MySQL, or Access? Your clients would LOVE you if you could provide comprehensive documentation about the databases you build. Are you a Project Manager who is tired of developers making changes to databases on live servers and not updating the corresponding spec? SqlSpec will make sense of it all and generate easy-to-read docs for you for any database on the following platforms: * SQL Server 2000/2005 * Oracle 9i (and above) * MySQL 5.0 (and above) * Analysis Server 2005 * Access 97/2000/XP/2003 SqlSpec generates documentation in two formats: HTML or CHM. HTML is useful for publishing your documents on the web or an intranet site. CHM is useful if you want a single, compact file containing all your documentation about one or more databases. The CHM is indexed so it is easily searchable for any keyword. This way you can easily determine which objects reference the "EmployeeID" column, for example. You can download a fully featured trial version here: http://www.elsasoft.org ...

I have a database on a network drive that I use for archiving purposes, but when the server is rebooted the database becomes suspect.
I created the db with the attached script and I am able to access it until I reboot the server. I've tried enabling flag 1807 via the SQL server service and the startup parameters of the instance. In all cases the database always come up suspect after a reboot. There was one instance where I was able to recover, but I am not sure how that happened. Does anyone have an idea of how I can reboot the server without the database becomming suspect? USE MASTER GO DBCC TRACEON(1807) GO --DBCC TRACEOFF(1807) --DBCC TRACESTATUS(1807) GO CREATE DATABASE ReadyNAS ON ( NAME = ReadyNAS_Data, FI...

automate startup /shutdown oracle database server 9i on redhat advance server 3.0
how i automate the oracle database 9i on RedHat Advance server 3.0 automatic startup and shutdown database in linux advance server 3.0 On Mon, 2 Aug 2004 17:06:37 +0500, "Kashif Hameed" <kashifh@shoa.net> wrote: >how i automate the oracle database 9i on RedHat Advance server 3.0 automatic >startup and shutdown database in linux advance server 3.0 > as usual: just read the documentation http://download-uk.oracle.com/docs/pdf/A96167_01.pdf (and please do so prior to posting as to avoid this type of questions) -- Sybrand Bakker, Senior Oracle DBA ...

Using preg_replace to convert '<?php*?>' to nothing (removing all PHP code)
Hi, I am trying to use preg_replace to take out all occurances of PHP code after reading (fread()) the contents of a PHP file. The code I am using is: $html = preg_replace("<?php*?>", "", $html); Unfortuntely it is not working and giving the following error: Warning: preg_replace(): Nothing to repeat for offset 0 in C:/apache/... Can someone please try this out and see what they get. How can I get this to work? Cheers Burnsy On 2 Sep 2005 13:57:49 -0700, bissatch@yahoo.co.uk wrote: >I am trying to use preg_replace to take out all occurances of PHP code ...

How to use icons (database, database backup, save, delete etc.) in Oracle forms 5? #2
Hello, Thanks for your reply. Could you plz inform me how should I set the environmental variable in order to attach the menus on buttons in an Oracle forms. Thanks Martin Martin wrote: > Hello, > > Thanks for your reply. > Could you plz inform me how should I set the environmental variable in > order to attach the menus on buttons in an Oracle forms. > > Thanks > > Martin You need to read the documentation. I say this because how to do it is operating system dependenat and partially because you need to invest a bit of effort on your own behalf and asking me to read the installation documentation for you is beyond the pale. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) ...

it's compatible oracle 8i client, compatible whith oracle 9i server (or oracle 10g server)
Hi all, I have a client/server application that work on the client with oracle 8i client connected to oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) , and I wonder if the client will work fine without upgrade version. Thanks Angel R. wrote: > Hi all, > I have a client/server application that work on the client with oracle 8i > client connected to > oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) > , and > I wonder if the client will work fine without upgrade version. > > Thanks If you have access to the metalink then check the connect matrix at http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=207303.1 Regards /Rauf ...

MySQL server for use with php
I'm learning mysql along with php. I got this book entitled MySQL weekend crash course but unfortunately it was missing the cd. The early chapter that sets up the database has the code to do this on the cd. The web site is www.mysqlwcc.com I tried to get a copy of the material on the cd from the web site. Maybe someone could help. I could use a good beginners tutorial. I got this at the library and it seems to be a fast way to get introduced to a lot of the mysql info. that one would need... a good manageable way to learn. Running out and buying a book is a bit hard right now, finan...

Database security
I have been reading a little that you should secure your PHP code to prevent SQL injection into a database (MySQL in my instance), mainly by checking the type of data to be put into a database, and if text, to addslashes() the data. What I have not managed to find out, is does SQL injection threaten the input of data into a database, ie a guestbook, or the reading of a database where the user would not know if the data is being read from a database? Is there anything else to consider to make a database more secure? In particular, I have read here a few months back that it's a good ...

MySQL database using php
hello friends i am new to php and mysql i designed a very simple database using mysql which have only two columns. one column is named as EventID in which IDs are increasing automatically. the other column is Event_Name in which i entered few names. now the problem is that when i tried to access that page using a php script i got an error. the php script which i wrote is as follows: <html> <head> <title>test program for accessing mysql db</title> </head> <body> <? echo"anubha"; $db =mysql_pconnect("192.168.0.10", "root"...

Question on Oracle Server 10g Install (.../oracle/oracle/.....
I am in the last stages of installing Oracle Server 10gR2 Enterprise Edition on a UNIX AIX server. When window "Execute Configuration Scripts" comes up it tells me to execute "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". The ".../oracle/oracle/..." stops me cold. I look back in my notes and everything I wrote suggests I had entered ".../oracle/product/....." for my ORACLE_HOME. I look at the install log in /u01/app/oracle/oraInventory/logs and see: "INFO: Setting variable 'ORACLE_HOME' to '/u01/app/oracle/oracle/product/10.2.0/d b_1'. Received the value from the command line." Did I really key /oracle/oracle/ instead of /oracle/ or did the OUI change the path for some reason????? Thank you, Bill bfogarty@gaports.com wrote: > I am in the last stages of installing Oracle Server 10gR2 Enterprise > Edition on a UNIX AIX server. When window "Execute Configuration > Scripts" comes up it tells me to execute > "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". > > The ".../oracle/oracle/..." stops me cold. I look back in my notes and > everything I wrote suggests I had entered ".../oracle/product/....." > for my ORACLE_HOME. I look at the install log in > /u01/app/oracle/oraInventory/logs and see: > "INFO: Setting variable 'ORACLE_HOME' to > '/u01/app/oracle/oracle/product/10.2.0/d > b_1'. Received the valu...

How Oracle SQL/PLSQL to access the other database
If I use either Generic ConnectivityGeneric Connectivity/Oracle Transparent Gateways, can i use non-oracle database table database realtime? ...

Web resources about - php code from plsql using owa htp.p - comp.databases.oracle.server

EMPLEOS JOBS Y NOTICIAS EN SELFOR21
Trabajos que Selfor desea cubrir y noticias de interés respecto a Recursos Humanos, con el propósito de comunicarlos a los Profesionales que ...

IT and Telecommunications Jobs in Sydney Metro - MyCareer
Find IT and Telecommunications Jobs in Sydney Metro on MyCareer. Fresh IT and Telecommunications Jobs posted daily. Free email alerts and salary ...

Scrum Developers Resources & References - Agile Pain Relief
This resource is new and under continual improvement. Please let us know if you experience any bugs or issues.

Terms and Conditions
Welcome to the American Girl Web site (the "Site"), currently located at http://www.americangirl.com . Please read the following rules and understand ...

Senior Programmer Analyst - J2EE . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Senior Programmer Analyst - J2EE job in Fairlawn, Ohio, US. Read the Senior Programmer Analyst - J2EE job description and find other Kforce Professional ...

Adam Renardson, Media Production
Adam Renardson, Media Production: The authoritative source of Adam Renardson's personal information, links, and social activity.

Oracle Developer - VitalityLife Systems
... stability. Competencies: Knowledge - Processes: SDLC. Unit Testing. Database structure design. Technical Change control. Technologies: PLSQL, ...

The Big Rewrite
You’ve got an existing, successful software product. You’ve hit the ceiling on extensibility and maintainability. Your project platform is inflexible, ...

Oracle Tips
Oracle News for the professional

Java and J2EE Programmer Practice Test - Free Java Tutorials
Free java guide website to learn Java programming through examples. Beginner's tutorials of plsql and sql with java source code

Resources last updated: 3/20/2016 2:45:10 AM