Re: Pro*C query problem

From: Ganesh Puranik <surya_at_usa.net>
Date: 1995/05/27
Message-ID: <3q8d3e$6ts_at_earth.usa.net>#1/1


> ee_d304_at_dcs.king.ac.uk (Nick Bailey) writes:
> I am having problems trying to get a query in my Pro*C program to acheive what I want it to. The query is as follows -
>
> EXEC SQL SELECT CNAME, CCLENGTH
> INTO cname, clength
> FROM COURSES WHERE CNAME=:name;
 

> Nick.

>>>>
The can think of the following common mistakes:

  1. cname is char (blank padded) but :name is not blank padded.
  2. :name is defined as varchar in Pro*C but name.len is not set properly.

Ganesh Puranik
Consultant, Surya Systems, Inc. Received on Sat May 27 1995 - 00:00:00 CEST

Original text of this message