Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?

1 回表示 (過去 30 日間)
Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?
I am having some problems using the Matlab Database toolbox to access an Oracle database. In the Visual Query builder, there are some tables from the database for which I cannot see the fields. When I select those table in the table list I get the following error messages:
??? Undefined function or variable 'getTheMetaData'.
Error in ==> D:\MATLAB6p5\toolbox\database\database\@cursor\columnnames.m
On line 46 ==> md = getTheMetaData(cursor.Fetch);
Error in ==> D:\MATLAB6p5\toolbox\database\vqb\querycallbacks.m
On line 749 ==> tmp = columnnames(ex);
??? Error while evaluating uicontrol Callback.
When I try to get the fields from the table using the following code:
db_connection = database('enrg','','') ;
query1 = 'select * from GEODE0310 where scn =1 and poste =1;' ;
cursor1 = exec(db_connection,query1) ;
message1 = cursor1.Message ;
message1
message1 =
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist

採用された回答

MathWorks Support Team
MathWorks Support Team 2009 年 6 月 27 日
To resolve this problem, create a synonym for the table. Also, specify the table in lower case or enclose it in double quotes:
query2 = 'select * from "AREAS" ;';

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeStructures についてさらに検索

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by