[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Creating view form in 9.1.2 Error:5165



**
Hi Kieth,

Not sure if this is related to synonyms, but I guess from version 9.1 view form doesnt support synonyms and you will have to convert them to actual database views.

Thanks,
Vinod Gaidhani.

On Mon, Dec 19, 2016 at 8:05 PM, Sinclair, Keith <ksinclair@shoppertrak.com> wrote:
**

List,

 

I am banging my head against the wall on this one as I am not finding out any decent information. I cannot create a view form that links to an external DB whereas the same view form in my 8.1.2 test system connects without issue.

 

I have gone through both systems and they seem to be an apples to apples comparison. Both DB links are public database links. Both are accessible and working inside SQL developer. Thoughts?

 

5165 Error

Table fields must have at least one column.

 

Table fields must have at least one column. See the section on Tables for more information.

 

91.2 Running RedHat on Oracle 11g

 

Keith Sinclair

Remedy Development

ShopperTrak Chicago, USA

O 312.676.8289

ksinclair@shoppertrak.com | shoppertrak.com

Retail Profitability, Improved.

 

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_