Re: Volunteers sought to help with or take over Oracle::OCI
- From: learn.tech123@xxxxxxxxx (Amit Saxena)
- Date: Mon, 21 Jul 2008 17:49:50 +0530
On Mon, Jul 21, 2008 at 5:23 PM, John Scoles <scoles@xxxxxxxxxxx> wrote:
I suppose I could take it over as I am doing DBD::Oracle as well.Hi !
cheers
John Scoles
Tim Bunce wrote:
The Oracle::OCI module provides access to the entire Oracle OCI
interface. Every feature Oracle offers can be accessed via OCI.
Including Transparent Application Failover (TAF) and bulk loading.
The Oracle::OCI module bootstraps itself at build time. Automatically
creating perl interfaces to all the OCI functions in your installed
version of Oracle.
It lets you write OCI code in perl:
OCIHandleAlloc($env, my $dschp, OCI_HTYPE_DESCRIBE, 0, 0);
OCIDescribeAny($dbh, $dbh, oci_buf_len($table), OCI_OTYPE_NAME, 1,
OCI_PTYPE_TABLE, $dschp);
OCIAttrGet($dschp, OCI_HTYPE_DESCRIBE, my $parmp, 0, OCI_ATTR_PARAM,
$dbh, 'OCIParamPtr');
OCIAttrGet($parmp, OCI_DTYPE_PARAM, my $numcols, 0, OCI_ATTR_NUM_COLS,
$dbh, 2);
OCIAttrGet($parmp, OCI_DTYPE_PARAM, my $collst, 0, OCI_ATTR_LIST_COLUMNS,
$dbh, 'OCIParamPtr');
That may seem a little low-level, but that's not the point.
This is an enabling technology and what it enables is huge:
access to the *entire* Oracle OCI interface.
Soon there'd be modules built on top of Oracle::OCI that provide
higher-level interfaces to specific areas of functionality, like LOBs,
bulk loading, objects, advanced queuing, etc etc.
Oracle::OCI also integrates very well with DBI and DBD::Oracle.
You can use a $dbh or $sth wherever it would be reasonable to.
I've not worked on it since 2001 as I very rarely use Oracle these days.
The Oracle::OCI module had moved beyond proof-of-concept but still
needs a little love before it's ready for prime-time.
Interesting? Interested?
Tim.
I am ready to help with what all I could contribute after my office hours
everyday and in weekends.
Let me know how I could be of any help in this initiative.
On technical competencies, I have good overview of Perl, Pro*C and
UNIX/Linux.
Regards,
Amit Saxena
- Follow-Ups:
- Re: Volunteers sought to help with or take over Oracle::OCI
- From: Tim Bunce
- Re: Volunteers sought to help with or take over Oracle::OCI
- References:
- Volunteers sought to help with or take over Oracle::OCI
- From: Tim Bunce
- Re: Volunteers sought to help with or take over Oracle::OCI
- From: John Scoles
- Volunteers sought to help with or take over Oracle::OCI
- Prev by Date: Re: Volunteers sought to help with or take over Oracle::OCI
- Next by Date: Re: Volunteers sought to help with or take over Oracle::OCI
- Previous by thread: Re: Volunteers sought to help with or take over Oracle::OCI
- Next by thread: Re: Volunteers sought to help with or take over Oracle::OCI
- Index(es):
Relevant Pages
|
