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

5 次查看（过去 30 天）
MathWorks Support Team
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
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 Exchange 中查找有关 Structures 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by