Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> pro*c question not running sql

pro*c question not running sql

From: sac <sachin.dhall_at_gmail.com>
Date: 23 Jan 2006 12:58:46 -0800
Message-ID: <1138049926.467012.230930@g43g2000cwa.googlegroups.com>


EXEC SQL INCLUDE SQLCA;
#include "stdio.h"
void main (void)
{
EXEC SQL BEGIN DECLARE SECTION;
char * uid ="SCOTT/TIGER";
int x=0;
EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT :uid;
printf("Connected as ....%s",uid);
EXEC SQL select sal into :x from emp where empno=7369; printf("..%d",x):
}

it compiles fine and makes the exe...no errors...

it shows the output as "Connected as ....SCOTT/TIGER..0" it is i think not executing the select statement ,i have tried selecting many other things same problem.....could you help please... Received on Mon Jan 23 2006 - 14:58:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US