• Error: PL/SQL: ORA-01733: virtual column not allowed here Line: 81 Text: MERGE INTO SvcOrderProfit Error: PL/SQL: SQL Statement ignored Line: 81 Text: MERGE INTO SvcOrderProfit 用merge ...
    Error: PL/SQL: ORA-01733: virtual column not allowed here
    Line: 81
    Text: MERGE INTO SvcOrderProfit

    Error: PL/SQL: SQL Statement ignored
    Line: 81

    Text: MERGE INTO SvcOrderProfit

    用merge into 的时候提示

    REF  :http://www.cnblogs.com/dongsheng/p/4384754.html


           SET IncomeRMB                    = pos_2,
               CostRMB                      = pos_3;/*,
               v_dIncomeUSDFee              = pos_4,
               v_dIncomeUSDAccount          = pos_5,
               v_dlCostUSDFee               = pos_6,
               v_dlCostUSDAccount           = pos_7,
               v_dIncomeRMBSales            = pos_8,
               v_dCostRMBSales              = pos_9,

    ROOT CAUSE 本来左边应该是表名,从SQL 转过来的时候却弄成了变量。所以报错 

    solution  :

    表字段的保留, 非表字段的SELECT INTO 到变量里面:

          SELECT NVL((SELECT SUM(SvcOrderFee.NoTaxFeeAmount)
                                  FROM SvcOrderFee
                                 WHERE SvcOrderFee.CurrencyType = 0
                                   AND SvcOrderFee.CreditDebitType = 0
                                   AND (SvcOrderFee.AccountType = 2 OR
                                       SvcOrderFee.AccountType = 3)
                                   AND SvcOrderFee.OrderBillID = v_lOrderBillID),

    INTO         v_dCostRMBSales  
                       FROM DUAL;

  • ORA-01733: virtual column not allowed here

    千次阅读 2015-03-17 16:43:35
    ORA-01733: virtual column not allowed here 更新视图1: SQL> update scott.tt set A=2; update scott.tt set A=2  * ERROR at line 1: ORA-01732: data manipulation operation not legal ...
     基表: hr.tt  scott.tt
     视图1: 基于 hr.tt  union all  scott.tt ---》 scott.ttt
     视图2: 基于 视图1-》scott.ttt 创建 system.tt

    SQL> create table hr.tt (a number);
    Table created.
    SQL>  create table lixora.tt (a number);
    Table created.

    SQL> create view  scott.tt as select * from  hr.tt union all select * from lixora.tt;
    View created.

    SQL> create view system.tt as select * from scott.tt;
    View created.

    SQL> select * from system.tt

    SQL> update  system.tt set a=2;
    update  system.tt set a=2
    ERROR at line 1:
    ORA-01733: virtual column not allowed here

    SQL> update  scott.tt set A=2;
    update  scott.tt set A=2
    ERROR at line 1:
    ORA-01732: data manipulation operation not legal on this view

    SQL> !oerr ora 1732
    ORA-01733: virtual column not allowed here 
    Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view. 
    Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view.


    无法对包含表达式的view 进行dml 操作

  • is not allowed" It happens because the MySQL connector tries to set a value in a column that is virtually generated (alias read-only). Please add a property attribute such as "ReadOnly" ...
  • <div><h3>Steps to ... 48:00:00 which was allowed in previous PMA versions) via the form field edit box now the JavaScript validator fails my 2 day time entry, when inserting into the column <code>...
  • <div><p>table with virtual field not should be in data backup</p><p>该提问来源于开源项目:ifsnop/mysqldump-php</p></div>
  • <p>By adding a few key <code>virtual_attributes, we are able to process over 100k records for <code>MiqProvisionVirtWorkflow#allowed_templates</code> in under 5 seconds, and use very limited memory....
  • Ignore virtual columns

    2021-01-09 09:17:50
    is not allowed.") </null></null></null></code></pre> <p>To insert data in such a table you have to omit these virtual columns: <pre><code>sql mysql root:test> INSERT INTO t(a...
  • Taisto Kasurinen is a Finnish coal miner whose father has just committed suicide and who is framed for a crime he did not commit. In jail, he starts to dream about leaving the country and starting a ...
  • <p>The question is whether it is allowed to define <code>aboutUrl</code> for an individual column, i.e., create a separate url for a specific cell in a role ("phantom" columns). If it is ...
  • , which always baffled me).</li><li>Use a virtual field so that the values are updated - Failed: No further use is then allowed, GroupStats does not recognise virtual fields, databases do not ...
  • 我想用存储过程实现将test1表中的数据一条一条地插入test2中,有点像列转行,但是原问题比这个复杂的多,**但是好像变量值不能作为insert into test2的字段名**,这个位置提示'virtual column not allowed here' ,...
  • update sequel

    2020-12-26 02:08:23
    While symbol splitting allowed for shorter code, it was not obvious and caused significant issues when using column names with embedded double or triple underscores. [...] </p><pre># To get back ...
  • General, Core, and Other are also allowed as types</li><li>OS type and version: <strong>GCP AI Notebook</strong> Python framework</li><li>Python version and virtual environment information: 3.7.6...
  • WPTools.v6.29.1.Pro

    2013-08-26 15:33:51
    * stream RTFvariables were not loaded from WPT format. They are loaded now. 9.11.2012 - WPTools 6.28 - Update to RTF reader to load landscape flag for sections better - when page mirror was used, ...
  • m using Kopano as mail backend with LMTP:2003 as default way via virtual_mailbox_domains, virtual_transport = lmtp:IP:2003 or transport = lmtp:IP:2003. <p>To add LMTP should work straight...
  • # mandatory, integer document ID field MUST be the first selected column sql_query = \ SELECT id, title, content FROM tt # joined/payload field fetch query # joined fields let you avoid...
  • <p>This is however not possible in .Net Core current version as it would hinder portability of apps created on .Net core with .Net framework. <p>...
  • If you plan on showing off some of your coursework publicly, you must share only files that you are allowed to. Do NOT disrespect the code of conduct that you signed in the beginning of each course! ...
  • As since the v2 plugin API hook methods are non virtual, there is no straight forward way to introduce an equally named wrapper-hook with a different signature (hook overloading is not supported)....
  • <div><p><strong>Describe the bug ...yaml.scanner.ScannerError: mapping values are not allowed here in "", line 37, column 7: tray:</p><p>该提问来源于开源项目:vinifmor/bauh</p></div>
  • info FIL_PROOFS_USE_GPU_COLUMN_BUILDER=1 FIL_PROOFS_USE_GPU_TREE_BUILDER=1 FIL_PROOFS_MAXIMIZE_CACHING=1 ./lotus-bench sealing --sector-size 32GiB 2>&1 | tee bench-$(date +%s)....
  • -DMAC_OS_X_VERSION_MAX_ALLOWED=1090', '-mmacosx-version-min=10.8', '-Wall', '-Wpointer-arith', '-Wcast-qual', '-Wcast-align', '-Wno-unused-...
  • updating my fork (#1)

    2020-11-30 02:50:11
    that were not recognized. We support all headers registered using the report_headers macro as well as names used when calling report_row macro, as illustrated in the following example <p><%- report...
  • <p>This is an INTERNAL... if non-empty, only allow entering these (comma seperated) values in the Classification column ; Note that this is purely a front-end restriction, designed to avoid accidental ...
  • option (Watchman crawler only) that adds virtual files to the Haste map ([#​6940](https://renovatebot.com/gh/facebook/jest/pull/6940)) ##### Fixes - `[jest-resolve]` Only resolve realpath ...
  • option allows to change the number of tests allowed to run concurrently ([#​7770](https://togithub.com/facebook/jest/pull/7770)) ##### Fixes - `[jest-runtime]` Fix for mocks not working ...
  • <div><p>We need to start the OpenSlides Server from our virtual environment via <pre><code> DJANGO_SETTINGS_MODULE=settings PYTHONPATH=/app/personal_data/var gunicorn -w 4 -b -k ...
  • messages within a certain range may not be found). The default +# is to calculate the time range on all open/available indices. +#disable_index_range_calculation = true + +# ...
  • in either Allowed or Block queries for 10-15 domains</li><li>FTL crashes</li></ul> <p><strong>Log file output [if available]</strong></p> <pre><code> [2020-07-18 03:45:29.152 17328/T18219] FTL has ...



1 2
收藏数 29
精华内容 11