问题描述
我有带有oracle形式的oracle数据库11g和报告11g.我创建了浏览按钮以从计算机或笔记本电脑目录打开CSV文件
I have oracle database 11g with oracle forms and reports 11g. I created browse button to open CSV File from computer or laptop directory
我在按下按钮时在触发器上使用此代码:
I am using this code on trigger when-button-press:
declare
filename varchar2(500);
begin
filename := GET_FILE_NAME(File_Filter=> ‘CSV Files
(*.Csv)|*.Csv|’);
:block2.FILE_NAME:= filename;
end;
当我按下按钮时，没有打开对话框.
When I pressed the button then did not open dialog box.
推荐答案
您的代码在Forms 6i上有效，前提是您已为webutil，但对于方法GET_FILE_NAME应该替换为CLIENT_GET_FILE_NAME，以便在本地文件系统而不是应用程序服务器中进行搜索，如下所示:
Your code works on Forms 6i provided you have properly attached the .olb and .pll files for webutil, but for Oracle Fusion Middleware 11g the method GET_FILE_NAME should be replaced with CLIENT_GET_FILE_NAME to search in your local file system instead of application server as below :
:block2.FILE_NAME := CLIENT_GET_FILE_NAME(File_Filter=> 'CSV Files (*.Csv)|*.Csv|');
这篇关于无法使用GET_FILE_NAME Oracle Forms打开对话框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！