"missing expression" with Oracle

Frank Coole

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

"missing expression" with Oracle

If I try to make a table active in the IDE which has a clob field, I get
the ORA error "missing expression". I can select the row in SQL PLUS. Is
there some secret handshake when using clob's with D4 and Oracle?

Russell L. Smit

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:"missing expression" with Oracle

Another shot in the dark: Make sure you are in a transaction because CLOB
locators are not persistent across transactions.

V/R
Russell L. Smith

Quote

Frank Cooley wrote in message <364873B8.92525...@dnaco.net>...
>If I try to make a table active in the IDE which has a clob field, I get
>the ORA error "missing expression". I can select the row in SQL PLUS. Is
>there some secret handshake when using clob's with D4 and Oracle?

Frank Coole

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:"missing expression" with Oracle

That rings a bell. You made me remember that I was able to open the table
sometime in the past. I couldn't write to it because I wasn't using
transactions, but I believe that I could at least open the table. I've since
built a test table with just a clob in it and I wonder if the problem is in
how I've defined it on the oracle side?

Quote

Russell L. Smith wrote:
> Another shot in the dark: Make sure you are in a transaction because CLOB
> locators are not persistent across transactions.

> V/R
> Russell L. Smith

> Frank Cooley wrote in message <364873B8.92525...@dnaco.net>...
> >If I try to make a table active in the IDE which has a clob field, I get
> >the ORA error "missing expression". I can select the row in SQL PLUS. Is
> >there some secret handshake when using clob's with D4 and Oracle?

Frank Coole

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:"missing expression" with Oracle

Ah! I solved it. My table had only a clob field. Apparently akey field
is needed to make the the clob work. adding a key ID field allowed me to
open the table.

Quote

"Russell L. Smith" wrote:

> Another shot in the dark: Make sure you are in a transaction because CLOB
> locators are not persistent across transactions.

> V/R
> Russell L. Smith

> Frank Cooley wrote in message <364873B8.92525...@dnaco.net>...
> >If I try to make a table active in the IDE which has a clob field, I get
> >the ORA error "missing expression". I can select the row in SQL PLUS. Is
> >there some secret handshake when using clob's with D4 and Oracle?

Other Threads

1. The keys "-"/"+"/"*"

2. "Syntax Error in expression" strange error

3. Error "Full dBase expressions not allowed"

4. Spooky "Type Mismatch in Expression" problem

5. quickreport "expression"-component output

6. REPORTSMITH ERROR "Expression too long"

7. Expression: [SenderName] LIKE "Michael"

8. "Missing comma" error with SQL statement

9. "Missing segment" GPF

10. Help with missing "System.pas"