oracle insert query failing + php

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 455,979 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,786 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 946 | Replies: 0

•

Join Date: Sep 2007

Posts: 13

Reputation: bhakti.thakkar is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

bhakti.thakkar bhakti.thakkar is offline

Offline

Newbie Poster

oracle insert query failing + php

Nov 29th, 2007

hi all,
i have a table whose structure is as below:
Name Null? Type
----------------------------------------- -------- ----------------
NEWSLETTER_ID NOT NULL NUMBER
SUBJECT_VC VARCHAR2(255)
MAILTYPE_VC VARCHAR2(50)
CONTENT_TXT CLOB
SCHEDULE_DT VARCHAR2(50)
SYSTEM_HOOK_VC VARCHAR2(50)
NSTATUS_SI NUMBER
TEMPLATE_ID NUMBER

i want to insert data in this table. below is my php script [i m using odbc to connect to oracle]

php script:

•

if ($Newsletter_ID=='') {
$nid = GetMaxID('Newsletter_ID','Newsletter_T');
$system_hook_VC=uniqid();

$nStatus_SI=0;

$sth=$db->prepare("insert into Newsletter_T (Newsletter_ID , Subject_VC , MailType_VC , Content_Txt , Schedule_DT , nStatus_SI , system_hook_VC , Template_ID) values (:var1, ubject_VC, :MailType_VC, chedule_DT , :Content_Txt, :nStatus_SI, :system_hook_VC, :Template_ID)");

$bindvars=array(
"var1" => $nid,
"Subject_VC" => $Subject_VC,
"MailType_VC" => $MailType_VC,
"Content_Txt" => $Content,
"Schedule_DT" => $Schedule_DT,
"nStatus_SI" => $nStatus_SI,
"system_hook_VC" => $system_hook_VC,
"Template_ID" => $Template_ID
);
print_r($bindvars);
$x=$db->execute($sth,$bindvars);
print_r($x);
}

but its failing. i m getting an error or DB: mismatch

values of bind variables are as follows:
Array ( [var1] => 1 [Subject_VC] => DIVIDEND TEMPLATE [MailType_VC] => html [Content_Txt] =>
Dear Shareholder,

BOARD MEETING NOTICE

We wish to inform you that, the Meeting of the Board of Directors of our Company is scheduled to be held on Monday, January 01, 2007 to take on record, amongst other business, the unaudited financial results and Segment-Wise Financial Report for quarter and half year Monday, January 01, 2007

We also wish to inform you that at the said Meeting, the Board of Directors will consider payment of Interim Dividend for the financial year

The Record for this Interim Dividend is Monday, January 01, 2007 and the date of payment is Monday, January 01, 2007

We request you to provide us with your ECS details before Monday, January 01, 2007 to enable us to remit dividend through ECS.

(please ignore if you have already given this details)

XXXXXXXXXXX

Company Secretary &
Vice President – Human Resources

[Schedule_DT] => 29-Nov-2007 [nStatus_SI] => 0 [system_hook_VC] => 474e5ba0c7520 [Template_ID] => 1 )

i m really going mad on this.

Please help me

Last edited by bhakti.thakkar : Nov 29th, 2007 at 2:29 am.