Hi!
I got a proble in retriving volumn values using OCI with Oracle8i.
I got a table cinsisting:
SCHEMANR, SCHEMANAME, QUESTION01,....,QUESTION100, MSG.
Now, this table only consists one row, whith 12 question. The 8 question left is filled with 'NULL'.
Do anybody know how I should do to retrieve QUESTIONS (NOT filled with NULL) dynamically??
'Cause I won't fetch ALL 100 coloumns just to figure out that I acutally only need the 12 i the beginning.
I also need to put the Question values into varibles (the questions will be splitted, but I want to minimize total time I have to access Oracle).....