Hi,
I am using the following code to connect to ORACLE 9i server from ipl file.The same code is running from the command prompt , but not from the teamsite.
Here with i am providing the code i am using, Configuration information and the error information.Please look into this and provide us the solution.
#!C:\iw-home\iw-perl\bin\iwperl
BEGIN{
$ENV{ORACLE_HOME} = 'C:\oracle\ora92';
$ENV{ORA_NLS} = 'C:\oracle\ora92\ocommon\nls\ADMIN\DATA';
$ENV{path} = 'C:\iw-home\iw-perl\bin;c:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin';
$ENV{perl} = 'C:\iw-home\iw-perl\bin';
};
use XML:
OM;
use DBI;
use TeamSite::Config;
my $iwHome = TeamSite::Config::iwgethome();
$db = DBI->connect("dbi
racle:host=172.16.5.182;sid=scb1;port=1521", "sony", "sony");
$sql_syntx="select table_name from HP_NEXT_ID";
$sth = $db->prepare($sql_syntx) or die "Cannot prepare SQL statement: $DBI::errstr\n";
$sth->execute or die "Cant execute SQL statement: $DBI::errstr\n";
my $count = 0;
my $values="";
my $out_file = "\n";
while (
@value = $sth->fetchrow_array())
{
$values="";
$tablenames = "
@value" . "\n";
$values = $values . $tablenames;
chomp($values);
$out_file .= ''."\n";
$count = $count + 1;
}
$sth->finish();
$out_file .= "\n";
print $out_file;
Configuration Information:
Teamsite: 6.7.1
Oracle : 9i Client & Server (Server is installed on a remote system)
perl : 5.8.2
DBD oracle: 1.19
Error Details:
Root cause:
DBI connect('host=172.16.5.182;sid=scb1;port=1521','sony',...) failed: ORA-12560: TNS
rotocol adapter error (DBD ERROR: OCIServerAttach) at C:\iw-home\iw-perl\bin\sample.ipl line 17 Can't call method "prepare" on an undefined value at C:\iw-home\iw-perl\bin\sample.ipl line 19.
Details...
com.interwoven.ui.datacapture.core.dct.InlineCallout$InlineCalloutException: DBI connect('host=172.16.5.182;sid=scb1;port=1521','sony',...) failed: ORA-12560: TNS
rotocol adapter error (DBD ERROR: OCIServerAttach) at C:\iw-home\iw-perl\bin\sample.ipl line 17
Can't call method "prepare" on an undefined value at C:\iw-home\iw-perl\bin\sample.ipl line 19.
at com.interwoven.ui.datacapture.core.dct.InlineCallout.execute(InlineCallout.java:181)
at com.interwoven.ui.datacapture.external.InlineCalloutProcessor.executeInline(InlineCalloutProcessor.java:188)
at com.interwoven.ui.datacapture.external.InlineCalloutProcessor.evaluateInlineCallouts(InlineCalloutProcessor.java:121)
at com.interwoven.ui.formspub.datacapture.DCRPredicate.buildDCRDocument(DCRPredicate.java:188)
at com.interwoven.ui.formspub.datacapture.NewDCRPredicate.execute(NewDCRPredicate.java:63)
at com.interwoven.ui.formspub.datacapture.NewDCRCommand.execute(NewDCRCommand.java:325)
at com.interwoven.ui.base.impl.command.CommandHandler.doExecuteCommand(CommandHandler.java:915)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandDescriptor(CommandHandler.java:752)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandID(CommandHandler.java:629)
at com.interwoven.ui.base.impl.command.CommandHandler.runCommand(CommandHandler.java:419)
at com.interwoven.ui.base.impl.command.CommandCallbackContextImpl.callback(CommandCallbackContextImpl.java:45)
at com.interwoven.ui.base.wizard.WizardCommand.execute(WizardCommand.java:115)
at com.interwoven.ui.base.impl.command.CommandHandler.doExecuteCommand(CommandHandler.java:915)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandDescriptor(CommandHandler.java:752)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandID(CommandHandler.java:629)
at com.interwoven.ui.base.impl.command.CommandHandler.runCommandLoop(CommandHandler.java:234)
at com.interwoven.ui.base.impl.command.CommandServlet.doGet(CommandServlet.java:163)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.interwoven.ui.base.impl.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:204)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.interwoven.ui.base.util.SetRequestEncodingFilter.doFilter(SetRequestEncodingFilter.java:105)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Please provide us the solution,Thanks in advance.
