Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
Concat and Declare variable in Oracleusing OCI

Posted by pagalreddy (pagalreddy), 24 October 2005
SqlServer Example:
$query = "declare @CMID numeric
exec @CMID = ".$CDatabaseOwner."InsertNewCM $GOrgID, '".$stRequester."', '".$stReasonCode."'
select @CMID as CMID";

OCI Example in Oracle
$query = OCIParse($link ,"BEGIN PKG_CMT_PROCS.InsertNewCM(:GOrgID,:stRequester,:stReasonCode,:p_CMID);END;");
OCIbindByName($query, "GOrgID", $GOrgID,1);      
OCIbindByName($query, "stRequester", $stRequester,100);      
OCIbindByName($query, "stReasonCode", $stReasonCode,100);
OCIbindByName($query, "p_cmid", $CMID, 10);
"select @CMID CMID";

$result = ociexecute($query) ;

Please tell me where iam doing wrong compared to Oracle and SqlServer.

I want to make this work in Oracle but forsome reason iam not able to get the CMID value, as I dont know how to declare in ORacle and also How to make Concat Work.


This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho