Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Object Data Types

Status
Not open for further replies.
synapsevampire

synapsevampire

Programmer
Mar 23, 2002
20,180
US
CR 8.5
Oracle 9

Has anyone CAST or CONVERTed an Oracle object data type within a View so that Crystal can work with the data?

Currently I have an object type which contains userid and timestamp which makes Crystal immediately throw up and close.

I tried the simple syntax of select inserted.userid from table but it returns an invalid column name error.

Any thoughts?

-k
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
SAP 2020 missing data
Replies
0
Views
72
Kennymc
Kennymc
john432
  • Locked
  • Question
Database Location Help
Replies
1
Views
236
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
704
Ivan Kok
Ivan Kok
dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
674
dgillz
dgillz
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
1K
LyleU
LyleU

Part and Inventory Search

Sponsor

Back
Top